Re: Inserting Data

What I have is one table which stores device_id numbers that are referenced
on the second table "library.devices".

I need to insert device_ids from the first table that satisfy the conditions
of the argument found on the library table. Hence the 'where' clause.

So far all I can get are errors when I attempt this procedure.

Hence - my problem.

Bob





----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Bob Pawley" <rjpawley@shaw.ca>
Cc: "Michael Fuhr" <mike@fuhr.org>; "Postgresql"
<pgsql-general@postgresql.org>
Sent: Wednesday, August 23, 2006 4:05 PM
Subject: Re: [GENERAL] Inserting Data


> Bob Pawley <rjpawley@shaw.ca> writes:
>>  insert into p_id.loops (monitor) values (new.devices_id)
>>  where new.device_number = library.devices.device_number
>>  and library.devices.type_ = 'mon' ;
>
> Huh?  How did library.devices get into this?  Are you trying to join to
> it, and if so why, seeing that the value you want to insert into
> p_id.loops is independent of that table?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster