Re: Inserting Data - Mailing list pgsql-general

From Bob Pawley
Subject Re: Inserting Data
Date
Msg-id 032501c6c951$f88f4270$8e904618@owner
Whole thread Raw
In response to Inserting Data  (Bob Pawley <rjpawley@shaw.ca>)
List 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 by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Something blocking in libpq_gettext?
Next
From: Gregory Stark
Date:
Subject: Re: copy command