I'm not arguing (I'm attempting to learn) - but this seems to be counter
intuitive when writing a procedure.
I know that it exists because, through the interface, I have selected it
from the same library table.
Could you explain why Postgresql simply doesn't accept the simple 'where'
statement that was in my earlier e-mail.
Bob
----- Original Message -----
From: "Tom Lane" <tgl@xxxxxxxxxxxxx>
To: "Bob Pawley" <rjpawley@xxxxxxx>
Cc: "Michael Fuhr" <mike@xxxxxxxx>; "Postgresql"
<pgsql-general@xxxxxxxxxxxxxx>
Sent: Wednesday, August 23, 2006 4:44 PM
Subject: Re: [GENERAL] Inserting Data
Bob Pawley <rjpawley@xxxxxxx> writes:
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.
This isn't real clear to me, but perhaps you are looking for something
like
IF EXISTS(select 1 from library.devices where ...) THEN
INSERT INTO ... values(new.device_id);
END IF;
regards, tom lane
