NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit31d5354

committed

Doc: improve documentation about random().

We didn't explicitly say that random() uses a randomly-chosen seedif you haven't called setseed(). Do so.Also, remove ref/set.sgml's no-longer-accurate (and never veryrelevant) statement that the seed value is multiplied by 2^31-1.Back-patch to v12 where set.sgml's claim stopped being true.The claim that we use a source of random bits as seed was debatablebefore4203842, too, so v12 seems like a good place to stop.Per question from Carl Sopchak.Discussion:https://postgr.es/m/f37bb937-9d99-08f0-4de7-80c91a3cfc2e@sopchak.me

1 parentfee0165 commit31d5354Copy full SHA for 31d5354

File tree

2 files changed

-2

lines changed

doc/src/sgml
- func.sgml
- ref
  - set.sgml

2 files changed

-2

lines changed

`‎doc/src/sgml/func.sgml‎`

Lines changed: 3 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1840,6 +1840,9 @@ repeat('Pg', 4) <returnvalue>PgPgPgPg</returnvalue>`
`1840`	`1840`	`subsequent <function>random()</function> calls in the current session`
`1841`	`1841`	`can be repeated by re-issuing <function>setseed()</function> with the same`
`1842`	`1842`	`argument.`
	`1843`	`+ Without any prior <function>setseed()</function> call in the same`
	`1844`	`+ session, the first <function>random()</function> call obtains a seed`
	`1845`	`+ from a platform-dependent source of random bits.`
`1843`	`1846`	`</para>`
`1844`	`1847`
`1845`	`1848`	`<para>`

`‎doc/src/sgml/ref/set.sgml‎`

Lines changed: 1 addition & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -175,8 +175,7 @@ SET [ SESSION \| LOCAL ] TIME ZONE { <replaceable class="parameter">timezone</rep`
`175`	`175`	`<para>`
`176`	`176`	`Sets the internal seed for the random number generator (the`
`177`	`177`	`function <function>random</function>). Allowed values are`
`178`		`- floating-point numbers between -1 and 1, which are then`
`179`		`- multiplied by 2<superscript>31</superscript>-1.`
	`178`	`+ floating-point numbers between -1 and 1 inclusive.`
`180`	`179`	`</para>`
`181`	`180`
`182`	`181`	`<para>`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit31d5354

File tree

2 files changed

2 files changed

`‎doc/src/sgml/func.sgml‎`

`‎doc/src/sgml/ref/set.sgml‎`

0 commit comments