Re: Inserting Data

Поиск
Список
Период
Сортировка
От Michael Fuhr
Тема Re: Inserting Data
Дата
Msg-id 20060826203628.GA46584@winnie.fuhr.org
обсуждение исходный текст
Ответ на Re: Inserting Data  (Bob Pawley <rjpawley@shaw.ca>)
Список pgsql-general
On Sat, Aug 26, 2006 at 01:22:49PM -0700, Bob Pawley wrote:
> What is the reason for redefining type_ as device_type ???

The function doesn't redefine type_; it selects the value of the
type_ column into a local variable named device_type to avoid
querying library.devices more than once.  That local variable must
have a different name to avoid syntax errors that would result from
the ambiguity of having a variable and a table column with the same
name.

--
Michael Fuhr

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