| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Peter Choe <choepete(at)mindspring(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: stored procedure |
| Date: | 2003-04-01 16:51:41 |
| Message-ID: | 20030401165141.GA16823@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Apr 01, 2003 at 11:26:47 -0500,
Peter Choe <choepete(at)mindspring(dot)com> wrote:
> 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.
Normally you multiply by the range you want and then you can make a cast.
Note however, that multiplication may cause a value to round up so that
(6*random())::int might on very rare occasions return 6 instead of the
expected 0, 1, 2, 3, 4 or 5. (At least on some systems.)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dennis Gearon | 2003-04-01 17:05:28 | Re: Newsgroups/sites for SQL questions? |
| Previous Message | Stephan Szabo | 2003-04-01 16:46:33 | Re: deferred constraint trigger problem |