| From: | Guido Weber <guido(at)castor(dot)atlas(dot)de> | 
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org | 
| Subject: | Operator <> for lseg,lseg bug | 
| Date: | 1998-10-28 12:34:16 | 
| Message-ID: | Pine.SGI.3.94.981028132859.29245A-100000@castor | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | 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(dot)guido(at)stn-atlas(dot)de  |  Germany                           |
-------------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1998-10-28 16:05:26 | Re: [SQL] Operator <> for lseg,lseg bug | 
| Previous Message | Jan Wieck | 1998-10-28 11:43:00 | Re: [SQL] Joining bug???? |