Postgres Pro
Downloads
Home   >   mailing lists

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

From Michael Glaesemann
Subject Re: Misnamed field in subquery does not cause error when field name exists in parent query
Date
Msg-id BC106A18-B0D3-492D-A4C6-2E60A7E207CA@seespotcode.net
Whole thread Raw
In response to Misnamed field in subquery does not cause error when field name exists in parent query  (Rick Innis <rick.innis@gmail.com>)
Responses Re: Misnamed field in subquery does not cause error when field name exists in parent query
List pgsql-sql
Tree view 
On Dec 22, 2007, at 17:12 , Rick Innis 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.

Michael Glaesemann
grzm seespotcode net

pgsql-sql by date:

Previous
From: Rick Innis
Date:
Subject: Misnamed field in subquery does not cause error when field name exists in parent query
Next
From: Louis-David Mitterrand
Date:
Subject: Re: passing a multiple join to a function?