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

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: Rick Innis <rick(dot)innis(at)gmail(dot)com>
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-23 00:14:26
Message-ID: BC106A18-B0D3-492D-A4C6-2E60A7E207CA@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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

In response to

Responses

Browse pgsql-sql by date

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