Re: [SQL] Crosstab question

2006-10-22 Thread Michael Fuhr
On Sun, Oct 22, 2006 at 01:57:09PM +0200, Leendert Paul Diterwich wrote: > The problem is that the data is being shifted when there is no > price for Supplier1 for product 3: > > Productnumber Supplier1 Supplier2 > 2 0.80.9 > 3

[SQL] Crosstab question

2006-10-22 Thread Leendert Paul Diterwich
Dear list,   I recently discovered the crosstab function in postgresql. What I’m trying to accomplish is turn this:   Suppliernumber Productnumber Price 0  2  0.8 0  3  1.2 1  2