Re: Misnamed field in subquery does not cause error when field name exists in parent query - Mailing list pgsql-sql

On 22-Dec-07, at 7:14 PM, Michael Glaesemann wrote:

>
>> It may be that SQL is doing exactly as it should, since 'id' is in  
>> scope within the subselect, but  if that's the case it's a nasty  
>> gotcha.
>
> Yes, and yes.

Ow. Thanks for confirming both my suspicions and my fears :-)

R.