From: | Zsolt Varga <redax(at)agria(dot)hu> |
---|---|
To: | Sferacarta Software <sferac(at)bo(dot)nettuno(dot)it> |
Cc: | PostgreSQL hackers list <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | Re: [HACKERS] BUG: NOT boolfield kills backend |
Date: | 1998-09-19 13:10:53 |
Message-ID: | Pine.LNX.3.96.980919150940.3376A-100000@lupus.agria.hu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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(at)agria(dot)hu |
| System Administrator | URL: http://www.agria.hu/ |
`----------------------------------------------------------'
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Meskes | 1998-09-19 13:19:30 | My patches |
Previous Message | Joost Kraaijeveld | 1998-09-19 12:17:28 | Windows NT port of Postgres |