Re: How to generate random bigint

2023-12-20 Thread Thomas Munro
On Thu, Dec 21, 2023 at 7:21 PM Tom Lane wrote: > Phillip Diffley writes: > > 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 > > g

Re: How to generate random bigint

2023-12-20 Thread Tom Lane
Phillip Diffley writes: > 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? Doesn't look like the

How to generate random bigint

2023-12-20 Thread Phillip Diffley
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

Re: psql crash with custom build on RedHat 7

2023-12-20 Thread Dominique Devienne
On Tue, Dec 19, 2023 at 7:58 PM Thomas Munro wrote: > On Wed, Dec 20, 2023 at 4:41 AM Dominique Devienne > wrote: > > On Tue, Dec 19, 2023 at 2:02 PM Thomas Munro > wrote: > >> On Wed, Dec 20, 2023 at 1:39 AM Dominique Devienne > wrote: > >> > Program received signal SIGSEGV, Segmentation faul