Boolean error

Поиск
Список
Период
Сортировка
От Fabien Fournier
Тема Boolean error
Дата
Msg-id 1101570070.20764.7.camel@localhost.localdomain
обсуждение исходный текст
Ответы Re: Boolean error  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Query on exception handling in PL/pgSQL
Следующее
От: Chris Green
Дата:
Сообщение: Can one alter the format of a numeric column?