Received: from mail.bremen.pop.de (root@mars.bremen.pop.de [193.100.96.9]) by hub.org (8.9.1/8.9.1) with ESMTP id HAA07567 for ; Wed, 28 Oct 1998 07:32:17 -0500 (EST) (envelope-from guido@castor.atlas.de) Received: from [141.200.40.66] (helo=dsit04.atlas.de) by mail.bremen.pop.de with smtp (Exim 2.02 #2) id 0zYUlY-0005d2-00 for pgsql-sql@postgresql.org; Wed, 28 Oct 1998 13:31:56 +0100 Received: by dsit04.atlas.de; (5.65v3.2/1.3/10May95) id AA06617; Wed, 28 Oct 1998 13:32:14 +0100 Received: from castor.atlas.de by dsit03.atlas.de (5.65v4.0/1.1.10.5/28May97-0309PM) id AA13500; Wed, 28 Oct 1998 13:32:13 +0100 Received: from localhost by castor via SMTP (940816.SGI.8.6.9/940406.SGI) for id NAA29464; Wed, 28 Oct 1998 13:34:17 +0100 Date: Wed, 28 Oct 1998 13:34:16 +0100 (MET) From: Guido Weber X-Sender: guido@castor To: pgsql-sql@postgresql.org Subject: Operator <> for lseg,lseg bug Message-Id: Mime-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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 ? Thanks Guido ------------------------------------------------------------------------- | Guido Weber | STN Atlas Elektronik GmbH, SLE3 | | Tel.: +49/421/457-4076 | Sebaldsbruecker Heerstr. 235 | | Fax : -3578 | D-28305 Bremen | | email: weber.guido@stn-atlas.de | Germany | -------------------------------------------------------------------------