Re: Inserting Data
От | Bob Pawley |
---|---|
Тема | Re: Inserting Data |
Дата | |
Msg-id | 032501c6c951$f88f4270$8e904618@owner обсуждение исходный текст |
Ответ на | Inserting Data (Bob Pawley <rjpawley@shaw.ca>) |
Список | pgsql-general |
Michael Thanks again for your help. Bob ----- Original Message ----- From: "Michael Fuhr" <mike@fuhr.org> To: "Bob Pawley" <rjpawley@shaw.ca> Cc: "Postgresql" <pgsql-general@postgresql.org> Sent: Saturday, August 26, 2006 1:36 PM Subject: Re: [GENERAL] Inserting Data > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings
В списке pgsql-general по дате отправления: