Ok, understood. One can access the columns of the main query from the subquery, therefore in my own query the column "id_compte" is found, therefore there is no error message.
Doesn't this count as a bug ?
Tricky, you could have something like: SELECT a.* FROM a WHERE (a1,a2) IN (SELECT a1,b3 FROM b ...)
If that's legal, then so is your query.
On Wed, Mar 16, 2005 at 02:24:48PM +0000, Richard Huxton wrote:
David Pradier wrote:
Actually, the column "id_compte" is the primary key of the table "compte". The column "id_compte" doesn't exist in the table "operation".
But i still don't understand why there is no error message, could you explain a little more ?
I think it's intended for use in the WHERE clause: SELECT a.* FROM a WHERE a1 IN (SELECT b3 FROM b WHERE b2=a2)
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
