Boolean error

From: Fabien Fournier <fabien(at)cyriacrea(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Boolean error
Date: 2004-11-27 15:41:09
Message-ID: 1101570070.20764.7.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

We are experiencing a strange error with the following request :

select cmp
from (select random () < 0.5 as cmp from pg_type) as tmp
where cmp;

With this request even false results are shown. This behaviour doesn't
appear when we don't join the boolean expression to a table to have
multiple lines. It is also seems to be independent of the selected
table.

Could you enlighten us about what is happening ?

Thanks !
--
Fabien Fournier

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2004-11-27 16:23:01 Re: row-level deadlock problem
Previous Message Kamil Kaczkowski 2004-11-27 14:40:11 Re: row-level deadlock problem