Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA10985; Tue, 23 Mar 93 04:24:20 -0800
Date: Tue, 23 Mar 93 04:24:20 -0800
Message-Id: <9303231224.AA10985@postgres.Berkeley.EDU>
From: tom@izf.tno.nl (Tom Vijlbrief)
Subject: not operator problem
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu

Hi Postgres developers,

There is a problem with `NOT'

PostQuel (geo): retrieve portal qi_3640_0 (cities.name,cities.population,cities.geo_loc,cities.oid)  where ((cities.country = "NORWAY"::char16) or (not (cities.country = "NETHERLANDS"::char16))) and (cities.geo_loc ---> "(3.483439,50.776711,8.238323,53.719131)"::box) 
WARN:Mar 23 13:21:18:fmgr_info: function 0: cache lookup failed

Result: R

As you see the not fails on the =(char16,char16) operator...
Without not the query runs as expected.

Tom