Re: Inserting Data - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Inserting Data
Date
Msg-id 20060826203628.GA46584@winnie.fuhr.org
Whole thread Raw
In response to Re: Inserting Data  (Bob Pawley <rjpawley@shaw.ca>)
List 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 by date:

Previous
From: Bob Pawley
Date:
Subject: Re: Inserting Data
Next
From: Michael Fuhr
Date:
Subject: Re: Can't populate database using Copy