Received: from candle.pha.pa.us (maillist@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.9.1/8.9.1) with ESMTP id LAA27041 for ; Wed, 28 Oct 1998 11:07:04 -0500 (EST) (envelope-from maillist@candle.pha.pa.us) Received: (from maillist@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id LAA17100; Wed, 28 Oct 1998 11:05:26 -0500 (EST) From: Bruce Momjian Message-Id: <199810281605.LAA17100@candle.pha.pa.us> Subject: Re: [SQL] Operator <> for lseg,lseg bug In-Reply-To: from Guido Weber at "Oct 28, 1998 1:34:16 pm" To: guido@castor.atlas.de (Guido Weber) Date: Wed, 28 Oct 1998 11:05:26 -0500 (EST) Cc: pgsql-sql@postgreSQL.org X-Mailer: ELM [version 2.4ME+ PL47 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit > Hi > > I was testing some things with the geometric datatype in Postgres (6.3) > and got some results out of selects that I did not expect. Doing a \do > in psql gave me: > > <--SNIP--> > <> |bool |float8 |float8 |not equal > <> |bool |int2 |int2 |not equal > <> |bool |int4 |int4 |not equal > <> |bool |lseg |lseg |equals > <> |bool |money |money |not equal > <> |bool |name |name |not equal > <> |bool |oid |oid |not equal > <--SNIP--> > > This looks like a wrong entry in one of the system tables. Any ideas which > one it is, and how to correct this ? Good eye. Yes, it was wrong. To fix it, edit /pgsql/src/include/catalog/pg_operator.h. Search for the strings 'lseq_eq'. The first instance is correct, but the second instance should be 'lseg_neq'. Then you must run initdb to reload the system tables. Another way to do this would be to do an update on 'pg_operator'. I believe the oid is 1586, and the field is oprcode, so you can try: update pg_operator set oprcode = 'lseg_neq' where oid = 1586 \do should then show the proper values. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026