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

Re: [HACKERS] BUG: NOT boolfield kills backend

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 (view raw or flat)
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/  |
`----------------------------------------------------------'


In response to

pgsql-hackers by date

Next:From: Michael MeskesDate: 1998-09-19 13:19:30
Subject: My patches
Previous:From: Joost KraaijeveldDate: 1998-09-19 12:17:28
Subject: Windows NT port of Postgres

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