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(at)gmx(dot)net http://yi.org/peter-e/