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

Поиск
Список
Период
Сортировка
От Michael Glaesemann
Тема Re: Misnamed field in subquery does not cause error when field name exists in parent query
Дата
Msg-id BC106A18-B0D3-492D-A4C6-2E60A7E207CA@seespotcode.net
обсуждение исходный текст
Ответ на Misnamed field in subquery does not cause error when field name exists in parent query  (Rick Innis <rick.innis@gmail.com>)
Ответы Re: Misnamed field in subquery does not cause error when field name exists in parent query
Список 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

В списке pgsql-sql по дате отправления:

Предыдущее
От: Rick Innis
Дата:
Сообщение: Misnamed field in subquery does not cause error when field name exists in parent query
Следующее
От: Louis-David Mitterrand
Дата:
Сообщение: Re: passing a multiple join to a function?