On Tue, Nov 27, 2012 at 2:13 AM, ssylla wrote:
> id_project|id_product
> 1|1
> 1|2
> 2|1
>
> How can I create an output like this:
> id_project|id_product1|id_product2
> 1|1|2
> 2|1|NULL
You can use the crostab() function from the tablefunc module
(http://www.postgresql.org/docs/9.2/static/tablef
2012/11/27 ssylla :
> assuming I have the following n:n relationship:
>
> intermediary table:
> t3
> id_project|id_product
> 1|1
> 1|2
> 2|1
>
> How can I create an output like this:
> id_project|id_product1|id_product2
> 1|1|2
> 2|1|NULL
I'd said the sample is too simplified — not clear which id_
