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: (view raw, whole thread or download thread mbox)
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!?
登記免費的 中文電子郵件 @
Get your free address at

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-2018 The PostgreSQL Global Development Group