Re: stored procedure

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