Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] How to display multiple rows in 1 row - Mailing list pgsql-sql

From Steve Midgley
Subject Re: [SQL] How to display multiple rows in 1 row
Date
Msg-id CAJexoSKdVebRKKNXN3TCsyLh9G+o7PyifCUw75o_P0ZrNxyEJA@mail.gmail.com
Whole thread Raw
In response to Re: [SQL] How to display multiple rows in 1 row  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-sql
Tree view

On Tue, Jan 10, 2017 at 7:40 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Tuesday, January 10, 2017, Steve Midgley <science@misuse.org> wrote:

Given the DDL at the bottom of my email (what I used to test), this sql statement works, I think:

select * from
(select a.id as a_id, * from table_a a
left join table_b b on a.id=b.id) a1
join table_c c on a1.a_id = c.id


Returns

"1.table_c";"1.table_c";1;"";;;"1.table_c";4;3
"2.table_c";"2.table_c";2;"";;;"2.table_c";3;4
"3.table_c";"3.table_c";3;"";;;"3.table_c";2;21


Aside from executing without error I don't see how this works at all. You cannot solve the posed problem by rearranging simple joins.

David J.

Ugh - my bad - I only checked the table_c data in my results and got what I was expecting. I'm out of time tonight to play with this - apologies for bogus response. I'll see if I can rectify tomorrow.

pgsql-sql by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [SQL] How to display multiple rows in 1 row
Next
From: Herwig Goemans
Date:
Subject: [SQL] why is PG NOT pushing where clause to VIEW ? Resulting in bad performance.