Operator <> for lseg,lseg bug - Mailing list pgsql-sql

From Guido Weber
Subject Operator <> for lseg,lseg bug
Date
Msg-id Pine.SGI.3.94.981028132859.29245A-100000@castor
Whole thread Raw
Responses Re: [SQL] Operator <> for lseg,lseg bug
List pgsql-sql
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                           |
-------------------------------------------------------------------------


pgsql-sql by date:

Previous
From: jwieck@debis.com (Jan Wieck)
Date:
Subject: Re: [SQL] Joining bug????
Next
From: Bruce Momjian
Date:
Subject: Re: [SQL] Operator <> for lseg,lseg bug