Re: Misnamed field in subquery does not cause error when field name exists in parent query

From: Rick Innis <rick(dot)innis(at)gmail(dot)com>
To: Michael Glaesemann <grzm(at)seespotcode(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Misnamed field in subquery does not cause error when field name exists in parent query
Date: 2007-12-24 19:25:33
Message-ID: D3AD3174-312F-4D33-B705-41FC255A89E9@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Broersma Jr 2007-12-26 00:20:53 Advice for generalizing trigger functions
Previous Message Pavel Stehule 2007-12-24 16:41:11 Re: slow query - only uses indices