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

Re: GENERAL] Boolean error

From: songsubosongtebo songsubosongtebo <songsubosongtebo(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: GENERAL] Boolean error
Date: 2004-11-28 03:54:09
Message-ID: 20041128035409.92766.qmail@web42110.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-general
The sql can be predigest to:
select random() from a where random()<0.5;
\d a
       Table "public.a"
 Column |  Type   | Modifiers
--------+---------+-----------
 a      | integer |
This query can get about a half rows in the table 'a'.
When search a row, postgresql calcuate random() twice.



_________________________________________________________
Do You Yahoo!?
登記免費的 @yahoo.com 中文電子郵件 @ http://chinese.mail.yahoo.com
Get your free @yahoo.com address at http://chinese.mail.yahoo.com

pgsql-general by date

Next:From: Joseph HealyDate: 2004-11-28 04:22:45
Subject: Re: SERIAL error
Previous:From: Bruce MomjianDate: 2004-11-28 03:23:33
Subject: Re: (b)trim anomalies

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