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