Search Postgresql Archives

Re: Inserting Data

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Let me explain.

I have a table called p_id.devices which accumulates the devices_id for a multitude of differing devices used in P&ID development.(Process Engineering)

I also have a table called library.devices which is ( or soon will be ) a detailed explanation of all of the particular devices available.

I accumulate the device_ids of the devices used during the P&ID development. What I need to do now is distribute the various devices to their own tables (Loops as well as others) based on the information found in the library.devices table. I'm trying to make best use of the relationship features of a relational data base.

However, I am frustrated by what appears to be a restrictive use of simple logic. I am sure there is a reason for developing general SQL and PostgreSQL in the manner in which it has developed. I am just trying to parse the details behind the structure as best I can.

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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux