Hello Zsolt,
venerdì, 18 settembre 98, you wrote:
ZV> Hi,
ZV> I just found an error in every postgres versions,
ZV> (I tried 6.2.1, 6.3.2, and 6.4beta1 )
ZV> if I have a table with boolean field, and I want to negate that field,
ZV> it's kills the backend process... meanwhile 'select not ( 'T'::bool )'
ZV> works well...
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! ;)
Jose'