Boolean error - Mailing list pgsql-general

From Fabien Fournier
Subject Boolean error
Date
Msg-id 1101570070.20764.7.camel@localhost.localdomain
Whole thread Raw
Responses Re: Boolean error
List 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



pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Query on exception handling in PL/pgSQL
Next
From: Chris Green
Date:
Subject: Can one alter the format of a numeric column?