Re: [HACKERS] BUG: NOT boolfield kills backend - Mailing list pgsql-hackers

On Fri, 18 Sep 1998, Sferacarta Software wrote:

|ZV> create table t1 ( b bool );
|ZV> insert into t1 values ( 'T' );
|
|ZV> select not b from t1;
|
|Wrong syntax.
|The logical operator must be used in WHERE condition.
|Try this:  SELECT b FROM t1 WHERE NOT b;
|It works! ;)
yes, but what I want is to list every touple,
and negate the bool field from 'T' -> 'F' and vica verse

    thanks.

    redax

.----------------------------------------------------------.
|Zsolt Varga            | tel/fax:   +36 36 422811         |
| AgriaComputer LTD     | email:     redax@agria.hu        |
| System Administrator  | URL:       http://www.agria.hu/  |
`----------------------------------------------------------'