Re: [BUGS] select where id=random()*something returns two results

2003-09-18 Thread Rod Taylor
> select * from quotes where id=1+round(random()* cast ((select max(id) > from quotes) as double precision)); > id | quote | > author > -+---+-- > --- > 187 | Vergib

Re: [BUGS] select where id=random()*something returns two results

2003-09-18 Thread Kris Jurka
On Fri, 19 Sep 2003, Ulrich Meis wrote: > select * from quotes where id=1+round(random()* cast ((select max(id) > from quotes) as double precision)); > id | quote | > author > -+---+

[BUGS] select where id=random()*something returns two results

2003-09-18 Thread Ulrich Meis
POSTGRESQL BUG REPORT TEMPLATE Your name : Ulrich Meis Your email address : u.meis ( at ) gmx ( dot ) de Sys