Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oFMWQ-0000xE-HV for pgsql-sql@arkaria.postgresql.org; Sat, 23 Jul 2022 21:18:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oFMWO-0007jY-9I for pgsql-sql@arkaria.postgresql.org; Sat, 23 Jul 2022 21:18:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oFMWO-0007jP-0F for pgsql-sql@lists.postgresql.org; Sat, 23 Jul 2022 21:18:48 +0000 Received: from mout.perfora.net ([74.208.4.197]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oFMWK-00081I-OK for pgsql-sql@lists.postgresql.org; Sat, 23 Jul 2022 21:18:46 +0000 Received: from [10.221.133.171] ([142.105.135.230]) by mrelay.perfora.net (mreueus004 [74.208.5.2]) with ESMTPSA (Nemesis) id 1Mq2KU-1nlEgd2mSw-00n6UA for ; Sat, 23 Jul 2022 23:18:41 +0200 Message-ID: Date: Sat, 23 Jul 2022 17:18:40 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.10.0 Content-Language: en-US To: pgsql-sql@lists.postgresql.org From: Carl Sopchak Subject: What seed does random() use if setseed() is not called first? Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Provags-ID: V03:K1:P1KRUIT55f2g2HDb5Q8xOndHlNJWWQmf9QALp1u315YByyoaC3e 8K+6ITpHhNJuwe5k5DqKHVCdCFi71+J3GDoIO0vYZGVpiAPc/o+goi3JTFCkhy7m52D6di8 oXexWEi07F+RTp0TAMgUBhASlJS+c3QBVKkvGNjhSVoEhfPhIUKW6lbnSx3dxJBEOaTniqF ovDxiHUoEptTm2abm4msQ== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:PJI9MF06Yi0=:w68KhFmo1dQJYO5bGnZvFA Po7VmZTOTQK4WAZn9Q6xAQ8oxboqZD0jD8cEUNOxFyXYRU+AHmqUfFrxQRhQ1K+W7bWsguPAf NDyT/GsfmZwjSrbrIXqGpRHdoEqokKiIWUBoZ7IRqW7PKwyEbayqCU5aKKCVKtViSiTdVa3I7 6biqdYIkX/QYQg5dd8o8H7rUToGr6AAYe0S3DYlXKA4uS7e6xeUOAghKaZeIZPMM/mEBzKDxu V4FAms93TYotYJB7Y8UKQEgvsOSaGruE3Z2vt6dLrW2f/OJ4snodtyMq4gH9OxMtq5fnTOHA6 o4PmeVFwglhRWd7tmJFUBWlrI/JU/Gcy6Qj9hPRakI97vYVuPAoGvxzdRPCC7YpGPovp1VXn9 EOlsnTfbufW+OEFhK9D2XQpDRRAGEjBkwqGkLRDB8feIcsG5IDX620lAqNcAry+xGPVrmhHAX oMsIBkCuYCSprk9lXO8oNTCkl021I3AXVL9MZAOo5q85NKC2V+wj1ADpVyvUsQRvUc6HeK6iF lPy5MYbBuqQRi9nyHEepEap9+OoN/zse2CoyKAM8Z5ZzOeqeqOehcqAP++v1w0JGBAEGFLQGc Mj+isIilfeQg4oPYqtvFm1BvtMrwfgOGQKLs8RGEOfuoFi1YiLtmTIB7XCqxWdn4aF8W2bfQE e5YvIlSA8M4fpALHLbE9OO0E1RNvYLAPUSkHDZ71mVuyRuNJhwLAOCuF0w3NnMPvLDbQjVixV UEwDojMnLwf3REkfiBOV7B3LtBzAWz3J+2rD5Q== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk

There is one point about the documentation for random() and setseed() that is missing. What is used to seed random() if setseed() isn't called first? I assume it's something like /dev/random or /dev/urandom, but that's just a guess. Can someone please enlighten me?

Thanks for the help!

Carl