Re: Inserting Data

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