Here's what I want to do.
Table control contains values (mon and valves) that are associated by
numbers inserted into the associated column.
I want to transfer the serial _id number of the items associated by the
value '1' into the appropriate columns of the first row of the table
auto_control. All items associated with the value '2' into the second row -
etc. etc.
Is this best accomplished by a 'group by' command or subset???
Bob
Control
device_ID type association
serial varchar int4
1 mon 1
2 valve 2
3 valve 1
4 mon 2
5 valve 1
Auto_control
loop_id mon valve valve
serial int4 int4 int4
1 1 3 5
2 2 4
----- Original Message -----
From: "Guy Rouillier" <guyr@masergy.com>
To: "Postgre General" <pgsql-general@postgresql.org>
Sent: Monday, November 21, 2005 4:25 PM
Subject: Re: [GENERAL] Group By?
Converted your message to plain text as preferred on most mailing lists.
Bob Pawley wrote:
> I want to take the serial ID of several values in different rows in
> one table and insert them into a single row of another table.
>
> Would the 'group by' command be the best way to do this?
Could you provide an actual example? The wording of your question is a
little vague and an example might help solicit an answer to the actual
problem. For example, are these serial ID values all in a the same
column in the source table? Or is each one in a different column? And
what is the selection criteria that brings these results together?
--
Guy Rouillier
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
