> hello everyone
>
> is there a PSQL function that will return a random integer or
> BigInt value?
> I want to make a stored procedure that will insert a random number as
> the primary key of a record.
> I have good reasons why I not want to use a incremental generator.
>
> thanx
>
> Yiorgos

I don't know of any randomising function that I would trust with PK
generation.
If you want a PK which is not indexable as to the sequence of insert, then
perhaps you should use the UUID functions to generate a UUID
Alan


[Non-text portions of this message have been removed]