Re: BOOLEAN data type?

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: BOOLEAN data type?
Дата
Msg-id Pine.LNX.4.30.0104131850590.945-100000@peter.localdomain
обсуждение исходный текст
Ответ на BOOLEAN data type?  ("Josh Berkus" <josh@agliodbs.com>)
Ответы Re: BOOLEAN data type?  ("Josh Berkus" <josh@agliodbs.com>)
Список pgsql-sql
Josh Berkus writes:

> That the following query:
>
> SELECT detail_id FROM order_detials
> WHERE order_usq = 7703 AND detail_required;
>
>  ... should be equivalent to:
>
> SELECT detail_id FROM order_detials
> WHERE order_usq = 7703 AND detail_required = TRUE;
>
> However, in testing (7.1 RC2), the query turned out to mean this:
>
> SELECT detail_id FROM order_detials
> WHERE order_usq = 7703 AND detail_required IS NOT NULL;

No way.  You're doing something wrong.  How about showing the data that
makes you believe this?

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/



В списке pgsql-sql по дате отправления:

Предыдущее
От: "Josh Berkus"
Дата:
Сообщение: BOOLEAN data type?
Следующее
От: Tom Lane
Дата:
Сообщение: Mailing list gripes (was Re: Re: Maybe a Bug, maybe bad SQL)