Re: stored procedure - Mailing list pgsql-general

From Peter Choe
Subject Re: stored procedure
Date
Msg-id 3E89BDC7.5040405@mindspring.com
Whole thread Raw
In response to stored procedure  (Peter Choe <choepete@mindspring.com>)
Responses Re: stored procedure
List pgsql-general
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
 

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Newsgroups/sites for SQL questions?
Next
From: Dennis Gearon
Date:
Subject: Re: Log the SQL Statements