Skip site navigation (1) Skip section navigation (2)

Re: random() function produces wrong range

From: Guo Bin <guobin_(at)yahoo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgreSQL(dot)org, pgsql-general(at)postgreSQL(dot)org
Subject: Re: random() function produces wrong range
Date: 2000-08-02 06:54:44
Message-ID: 20000802065444.9055.qmail@web218.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Hope this function won't be removed. I'm using it
to select a random row like "select xxx from yyy
order by random() limit 1". It's painful to do it
before 7.0.

Regards,
-- 
Guo Bin

--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 
> As far as I can find, random() isn't mentioned in the
> documentation
> currently, so there probably aren't many people using
> it...
> 
> 			regards, tom lane


__________________________________________________
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/

pgsql-hackers by date

Next:From: Nico DDate: 2000-08-02 06:57:11
Subject: set-of-pointer valued attributes - help!
Previous:From: Thomas LockhartDate: 2000-08-02 06:10:34
Subject: Re: [HACKERS] random() function produces wrong range

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group