Home > mailing lists

output query on many to many relationship into several columns - Mailing list pgsql-sql

From	ssylla
Subject	output query on many to many relationship into several columns
Date	November 27, 2012 16:37:30
Msg-id	1354010394000-5733692.post@n5.nabble.com Whole thread Raw
List	pgsql-sql

Tree view

Dear list,

assuming I have the following n:n relationship:

t1:


t2:


intermediary table:
t3


How can I create an output like this:






--
View this message in context:
http://postgresql.1045698.n5.nabble.com/output-query-on-many-to-many-relationship-into-several-columns-tp5733692.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.

pgsql-sql by date:

From: Pavel Stehule
Date: 27 November 2012, 15:36:33
Subject: Re: Using regexp_matches in the WHERE clause

From: ssylla
Date: 27 November 2012, 16:37:39
Subject: select on many-to-many relationship

output query on many to many relationship into several columns - Mailing list pgsql-sql

Previous

Next