thanks. i just tried it out and it seems that it would generate a random number between 0 and 1. is that a valid assumption? if that is the case, how can i cast it to an int value? i assume that there is a cast function somewhere, but i can't tell by the names of the pronames.
Peter Choe
Bruno Wolff III wrote:
On Tue, Apr 01, 2003 at 09:36:28 -0500, Peter Choe <choepete@mindspring.com> wrote:
is there a listing of the built in procedure and what they do? i did
'select * from pg_proc' and got the names, but i don't know what they
actually do.
what i am looking for is some random character generator function. is
there anything like that in postgres?
There is a random function which you could use to get character data
(using a table lookup if nothing else). I wouldn't use that random
number generator for anything security related where the cost of
failure is high. It also might not be suitable for some kinds of
data analysis.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html