Horton

Re: [HACKERS] BUG: NOT boolfield kills backend

Zsolt Varga <redax@agria.hu>

View thread
From: Zsolt Varga <redax@agria.hu>
To: Sferacarta Software <sferac@bo.nettuno.it>
Cc: PostgreSQL hackers list <pgsql-hackers@postgreSQL.org>
Date: 1998-09-19T13:10:53Z
Lists: 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/  |
`----------------------------------------------------------'