{"Entry":{"collection":"func","key":"random-normal","name":"random_normal","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"15","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"16"}],"content_hash":"97615ccbc637fe1c85d2467c9b59096b31a0139dc465bb29273cc2917347196c","derived_content_hash":"2436fbe0e944ceace67617e4dc40036da03332207ba0ae48caf82011756b79a7","documentation_refresh":{"batch":"20261113","original_source_rev":"wiki-repair-20261023:f4226501843909d8a60ef5a7e2f0748876348798e019765f33d63e919aafed07","versions":{"16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"first_version":"16","group":"math","group_label":"Mathematical Functions And Operators","groups":["math"],"imported_at":"2026-09-27T17:57:28.249736+08:00","last_version":"20","name":"random_normal","name_key":"random_normal","position":2041,"present_in":["16","17","18","19","20"],"repair_provenance":{"original_source_revision":"b7bd9cda","receipt_sha256":"822869ad654872b02cdef39273711af1a0a820957835f07e6cc3d463df5efde4","repair":"wiki-repair-20261023"},"signature":"random_normal ( [ mean double precision [, stddev double precision ]] ) → double precision","signature_count":1,"slug":"random-normal","source_rev":"wiki-repair-20261023:f4226501843909d8a60ef5a7e2f0748876348798e019765f33d63e919aafed07","summary":"Returns a random value from the normal distribution with the given parameters; mean defaults to 0.0 and stddev defaults to 1.0","summary_zh":""}},"Definition":{"Collection":"func","Key":"random-normal","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"random-normal","SourceRevision":"wiki-repair-20261023:f4226501843909d8a60ef5a7e2f0748876348798e019765f33d63e919aafed07","Facts":{"description":"Returns a random value from the normal distribution with the given parameters; mean defaults to 0.0 and stddev defaults to 1.0","description_html":"Returns a random value from the normal distribution with the given parameters; \u003cem class=\"parameter\"\u003e\u003ccode\u003emean\u003c/code\u003e\u003c/em\u003e defaults to 0.0 and \u003cem class=\"parameter\"\u003e\u003ccode\u003estddev\u003c/code\u003e\u003c/em\u003e defaults to 1.0","description_zh":"从具有给定参数的正态分布中返回一个随机值；mean 默认为 0.0，stddev 默认为 1.0。","description_zh_html":"从具有给定参数的正态分布中返回一个随机值；\u003cem class=\"parameter\"\u003e\u003ccode\u003emean\u003c/code\u003e\u003c/em\u003e 默认为 0.0，\u003cem class=\"parameter\"\u003e\u003ccode\u003estddev\u003c/code\u003e\u003c/em\u003e 默认为 1.0。","doc":{"anchor":"FUNCTIONS-MATH-RANDOM-TABLE","file":"functions-math.html","sha256":"80bdcd3a2c7112aadf400e832cc7c8ee55e389d9b3c12e767c3fbb2b3364ef7b","slug":"18"},"documentation_revision":{"inputs":[{"file":"functions-math.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"80bdcd3a2c7112aadf400e832cc7c8ee55e389d9b3c12e767c3fbb2b3364ef7b","version":"18.7"},{"file":"functions-math.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"b48c7e1d8abf0f030ad0ef2aa1403db7015a96af265d49a15eaa2f1945a13a5f","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"},"group":"math","group_label":"数学函数和操作符","lang":"en","layout":"table-new","pages":["functions-math.html"],"prose_only":false,"signatures":[{"description":"Returns a random value from the normal distribution with the given parameters; mean defaults to 0.0 and stddev defaults to 1.0","description_html":"Returns a random value from the normal distribution with the given parameters; \u003cem class=\"parameter\"\u003e\u003ccode\u003emean\u003c/code\u003e\u003c/em\u003e defaults to 0.0 and \u003cem class=\"parameter\"\u003e\u003ccode\u003estddev\u003c/code\u003e\u003c/em\u003e defaults to 1.0","description_zh":"从具有给定参数的正态分布中返回一个随机值；mean 默认为 0.0，stddev 默认为 1.0。","description_zh_html":"从具有给定参数的正态分布中返回一个随机值；\u003cem class=\"parameter\"\u003e\u003ccode\u003emean\u003c/code\u003e\u003c/em\u003e 默认为 0.0，\u003cem class=\"parameter\"\u003e\u003ccode\u003estddev\u003c/code\u003e\u003c/em\u003e 默认为 1.0。","examples":[{"expr":"random_normal(0.0, 1.0)","result":"0.051285419"}],"html":"\u003ccode class=\"function\"\u003erandom_normal\u003c/code\u003e ( [\u003cspan class=\"optional\"\u003e\u003cem class=\"parameter\"\u003e\u003ccode\u003emean\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003edouble precision\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estddev\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003edouble precision\u003c/code\u003e\u003c/span\u003e]\u003c/span\u003e] ) → \u003ccode class=\"returnvalue\"\u003edouble precision\u003c/code\u003e","returns":"double precision","text":"random_normal ( [mean double precision [, stddev double precision]] ) → double precision","zh_from":"same-version-manual"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/functions-math.html","sha256":"b5f393c537ea29401867ea8b97292650ee67b0dd9e8cde535aae77bc594b3736"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-MATH-RANDOM-TABLE","file":"functions-math.html","sha256":"80bdcd3a2c7112aadf400e832cc7c8ee55e389d9b3c12e767c3fbb2b3364ef7b","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"random-normal","SourceDatabase":"center","Version":"18","Locale":"en","Title":"random_normal","Summary":"Returns a random value from the normal distribution with the given parameters; mean defaults to 0.0 and stddev defaults to 1.0","BodyHTML":"Returns a random value from the normal distribution with the given parameters; \u003cem\u003e\u003ccode\u003emean\u003c/code\u003e\u003c/em\u003e defaults to 0.0 and \u003cem\u003e\u003ccode\u003estddev\u003c/code\u003e\u003c/em\u003e defaults to 1.0","SourceRevision":"wiki-repair-20261023:f4226501843909d8a60ef5a7e2f0748876348798e019765f33d63e919aafed07","ContentHash":"3539ee3271c00309505cba7f16c54f0dc0641ed7797f0c627cfb9ed1329f54df","Payload":{"description":"Returns a random value from the normal distribution with the given parameters; mean defaults to 0.0 and stddev defaults to 1.0","description_html":"Returns a random value from the normal distribution with the given parameters; \u003cem class=\"parameter\"\u003e\u003ccode\u003emean\u003c/code\u003e\u003c/em\u003e defaults to 0.0 and \u003cem class=\"parameter\"\u003e\u003ccode\u003estddev\u003c/code\u003e\u003c/em\u003e defaults to 1.0","signatures":[{"description":"Returns a random value from the normal distribution with the given parameters; mean defaults to 0.0 and stddev defaults to 1.0","description_html":"Returns a random value from the normal distribution with the given parameters; \u003cem class=\"parameter\"\u003e\u003ccode\u003emean\u003c/code\u003e\u003c/em\u003e defaults to 0.0 and \u003cem class=\"parameter\"\u003e\u003ccode\u003estddev\u003c/code\u003e\u003c/em\u003e defaults to 1.0","description_zh":"从具有给定参数的正态分布中返回一个随机值；mean 默认为 0.0，stddev 默认为 1.0。","description_zh_html":"从具有给定参数的正态分布中返回一个随机值；\u003cem class=\"parameter\"\u003e\u003ccode\u003emean\u003c/code\u003e\u003c/em\u003e 默认为 0.0，\u003cem class=\"parameter\"\u003e\u003ccode\u003estddev\u003c/code\u003e\u003c/em\u003e 默认为 1.0。","examples":[{"expr":"random_normal(0.0, 1.0)","result":"0.051285419"}],"html":"\u003ccode class=\"function\"\u003erandom_normal\u003c/code\u003e ( [\u003cspan class=\"optional\"\u003e\u003cem class=\"parameter\"\u003e\u003ccode\u003emean\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003edouble precision\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estddev\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003edouble precision\u003c/code\u003e\u003c/span\u003e]\u003c/span\u003e] ) → \u003ccode class=\"returnvalue\"\u003edouble precision\u003c/code\u003e","returns":"double precision","text":"random_normal ( [mean double precision [, stddev double precision]] ) → double precision","zh_from":"same-version-manual"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"66b55301f087a2503266a32f04d0f49749c7ec72e2bbbc88ffcc0ae6b8f75407","Text":"random_normal ( [mean double precision [, stddev double precision]] ) → double precision","Returns":"double precision","Payload":{"description":"Returns a random value from the normal distribution with the given parameters; mean defaults to 0.0 and stddev defaults to 1.0","description_html":"Returns a random value from the normal distribution with the given parameters; \u003cem class=\"parameter\"\u003e\u003ccode\u003emean\u003c/code\u003e\u003c/em\u003e defaults to 0.0 and \u003cem class=\"parameter\"\u003e\u003ccode\u003estddev\u003c/code\u003e\u003c/em\u003e defaults to 1.0","description_zh":"从具有给定参数的正态分布中返回一个随机值；mean 默认为 0.0，stddev 默认为 1.0。","description_zh_html":"从具有给定参数的正态分布中返回一个随机值；\u003cem class=\"parameter\"\u003e\u003ccode\u003emean\u003c/code\u003e\u003c/em\u003e 默认为 0.0，\u003cem class=\"parameter\"\u003e\u003ccode\u003estddev\u003c/code\u003e\u003c/em\u003e 默认为 1.0。","examples":[{"expr":"random_normal(0.0, 1.0)","result":"0.051285419"}],"html":"\u003ccode class=\"function\"\u003erandom_normal\u003c/code\u003e ( [\u003cspan class=\"optional\"\u003e\u003cem class=\"parameter\"\u003e\u003ccode\u003emean\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003edouble precision\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estddev\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003edouble precision\u003c/code\u003e\u003c/span\u003e]\u003c/span\u003e] ) → \u003ccode class=\"returnvalue\"\u003edouble precision\u003c/code\u003e","returns":"double precision","text":"random_normal ( [mean double precision [, stddev double precision]] ) → double precision","zh_from":"same-version-manual"}}],"Spellings":null,"SQLState":null,"Evidence":null}