Re: [SQL] Bug? Me or PostgreSQL.

2001-02-18 Thread Tod McQuillin
On Mon, 19 Feb 2001, Christopher Sawtell wrote: > How can this happen? > > chris=# select name from boys_names where > boys_names.number=(random()*225+1)::int4; > name > > Fred > Gunnar > Manuel > Rainer > (4 rows) It's not clear what you expected to see -- I'll guess you expected

Re: [SQL] Bug? Me or PostgreSQL.

2001-02-18 Thread Tom Lane
Christopher Sawtell <[EMAIL PROTECTED]> writes: > How can this happen? > chris=# select name from boys_names where > boys_names.number=(random()*225+1)::int4; > name > > Fred > Gunnar > Manuel > Rainer > (4 rows) Er, what's your complaint exactly? It's not obvious to me that the

[SQL] Bug? Me or PostgreSQL.

2001-02-18 Thread Christopher Sawtell
Greetings, How can this happen? chris=# select name from boys_names where boys_names.number=(random()*225+1)::int4; name Fred Gunnar Manuel Rainer (4 rows) Here is the table declaration: create table boys_names ( number serial primary key, name