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(at)mindspring(dot)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
>
>
>