Search Postgresql Archives

Re: Group By?

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

 



Bob Pawley wrote:
> Bruno
> 
> The table I previously sent came through distorted and probabley
> caused misunderstanding.
> 
> The table control and auto_control are both permanent table. I want to
> reshuffle how the information is associated from one table to another
> with the link between table by way of the device_id.
> 
> Following is the example which I stabilized and tested for e-mail.

Sorry, Bob, I think the reason you haven't gotten a response is that the
information you are trying to convey below is very unclear.  Perhaps you
can just provide a create table statement and a bunch of insert
statements?  Then summarize again what you are trying to accomplish.

> 
> 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_a
>      valve_b
> 
>       serial
>      int4
>      int4
>      int4
> 
> 
> 
> 
> 
> 
>       1
>      1
>      3
>      5
> 
>       2
>      2
>      4
> 
> 
> 
> 
> 
> 
> 
> 
> ----- Original Message -----
> From: "Bruno Wolff III" <bruno@xxxxxxxx>
> To: "Bob Pawley" <rjpawley@xxxxxxx>
> Cc: "Guy Rouillier" <guyr@xxxxxxxxxxx>; "Postgre General"
> <pgsql-general@xxxxxxxxxxxxxx>
> Sent: Monday, November 21, 2005 10:07 PM
> Subject: Re: Group By?
> 
> 
>> On Mon, Nov 21, 2005 at 21:53:10 -0800,
>>  Bob Pawley <rjpawley@xxxxxxx> wrote:
>>> 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.
>> 
>> You don't really want to do that. Tables have fixed numbers of
>> columns and what you want to do doesn't result in a fixed number of
>> columns. 
>> 
>> If you want to generate a report with that format, then I think there
>> is a contrib module (crosstabs?) that will do this kind of thing. You
>> could also have a report app do it for you. In the report app method,
>> you would be best to return rows ordered by association and then
>> device_ID and have the app check for when the association value
>> changes. 
>> 
>>> 
>>> 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@xxxxxxxxxxx>
>>> To: "Postgre General" <pgsql-general@xxxxxxxxxxxxxx>
>>> 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
>>> 
>>> 
>>> ---------------------------(end of
>>> broadcast)---------------------------
>>> TIP 4: Have you searched our list archives?
>>> 
>>>               http://archives.postgresql.org



-- 
Guy Rouillier



[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