Re: [HACKERS] SELECT BUG - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] SELECT BUG
Date
Msg-id 27299.936711326@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] SELECT BUG  (José Soares <jose@sferacarta.com>)
List pgsql-hackers
José Soares <jose@sferacarta.com> writes:
> Yes, Tom, now it works, but...
> Informix gives me a different result. Who is right ?

Hard to tell, since I don't know what your data is.

> prova=> update pg_operator set oprcanhash = 'f' where oid = 1054;
> UPDATE 1
> prova=> select  mcode, dcode from master m, detail d where mcode=dcode;
> mcode      |dcode
> -----------+----------------
> a1         |a1
> a13        |a13
> a13        |a13
> (3 rows)

... but all three of those sure look equal to me ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] PostgreSQL 6.5.1: libpq++ libraries on IRIX 6.5
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] DROP TABLE inside transaction block