Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1J5b5x03967 for ; Mon, 19 Feb 2001 00:37:05 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f1J5b1921087; Mon, 19 Feb 2001 00:37:01 -0500 (EST) To: Christopher Sawtell cc: pgsql-sql@postgresql.org Subject: Re: Bug? Me or PostgreSQL. In-reply-to: <01021917450300.27125@berty> References: <01021917450300.27125@berty> Comments: In-reply-to Christopher Sawtell message dated "Mon, 19 Feb 2001 17:45:03 +1300" Date: Mon, 19 Feb 2001 00:37:01 -0500 Message-ID: <21084.982561021@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200102/302 X-Sequence-Number: 1498 Christopher Sawtell 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 there's anything wrong here. You seem to have gotten random matches on four rows --- if that's ridiculously too low (or too high) you'd better explain why you think so. regards, tom lane