> > ZV> create table t1 ( b bool );
> > ZV> insert into t1 values ( 'T' );
> > ZV> select not b from t1;
> > Wrong syntax.
> Not if he is trying to display the complement of a logical field
> rather than restrict a selection.
(I've lost who started this thread, so if it isn't "techguys" sorry for
It looks like "NOT anything" is pretty broken at the moment. However,
select b is false from t1;
to get what you want. The only problem with this is that it would mask
NULL fields if you have any.
In response to
pgsql-hackers by date
|Next:||From: Anand Surelia||Date: 1998-09-21 19:05:52|
|Subject: Foreign Keys: check_primary_function|
|Previous:||From: Thomas G. Lockhart||Date: 1998-09-21 17:04:08|
|Subject: Re: [firstname.lastname@example.org: Re: [HACKERS] BUG: NOT boolfield kills backend]|