Postgres Pro
Downloads
Home   >   mailing lists

How to generate random bigint - Mailing list pgsql-general

From Phillip Diffley
Subject How to generate random bigint
Date
Msg-id CAGAwPgQt6B0ORW_YfwsdRmWPhb_pG6c9HM7S=G4WGC_s8qaU+w@mail.gmail.com
Whole thread Raw
Responses Re: How to generate random bigint  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: How to generate random bigint  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
List pgsql-general
Tree view
Postgres's random() function generates a random double. That can be converted to a random int for smaller integers, but a double can't represent all of the values in a bigint. Is there a recommended way to generate a random bigint in Postgres?

Thanks,
Phillip

pgsql-general by date:

Previous
From: Dominique Devienne
Date:
Subject: Re: psql crash with custom build on RedHat 7
Next
From: Tom Lane
Date:
Subject: Re: How to generate random bigint