Re: Inserting Data
От | Bob Pawley |
---|---|
Тема | Re: Inserting Data |
Дата | |
Msg-id | 00cd01c6c715$12e13eb0$8e904618@owner обсуждение исходный текст |
Ответ на | Inserting Data (Bob Pawley <rjpawley@shaw.ca>) |
Ответы |
Re: Inserting Data
|
Список | pgsql-general |
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@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:44 PM Subject: Re: [GENERAL] Inserting Data > Bob Pawley <rjpawley@shaw.ca> 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
В списке pgsql-general по дате отправления: