Skip site navigation (1) Skip section navigation (2)

Re: [sferac@bo.nettuno.it: Re: [HACKERS] BUG: NOT boolfield kills backend]

From: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
To: Christopher Oliver <oliver(at)fritz(dot)traverse(dot)net>, techguys(at)traverse(dot)net
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [sferac@bo.nettuno.it: Re: [HACKERS] BUG: NOT boolfield kills backend]
Date: 1998-09-21 17:43:25
Message-ID: 3606903D.930DC219@alumni.caltech.edu (view raw or flat)
Thread:
Lists: pgsql-hackers
> > 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
the misdirection...)

It looks like "NOT anything" is pretty broken at the moment. However,
try

  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.

                  - Tom

In response to

pgsql-hackers by date

Next:From: Anand SureliaDate: 1998-09-21 19:05:52
Subject: Foreign Keys: check_primary_function
Previous:From: Thomas G. LockhartDate: 1998-09-21 17:04:08
Subject: Re: [sferac@bo.nettuno.it: Re: [HACKERS] BUG: NOT boolfield kills backend]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group