Re: Erratic error message "ERROR: column "id_compte" does

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 ?

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 6: Have you searched our list archives?
> 
>               http://archives.postgresql.org

-- 
dpradier@apartia.fr - tel: 01.46.47.21.33 - fax: 01.46.47.21.37