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 0.9 1 3 1.1 Into this: Productnumber Supplier1 Supplier2 2 0.8 0.9 3 1.2 1.1 The problem is that the data is being shifted when there is
no Productnumber Supplier1 Supplier2 2 0.8 0.9 3 1.1(WRONG!) I’m using this command to retrieve the data: select * from crosstab('select int_artnr, int_crednr,
flt_inkoopprijs from artcredinkoopprijzen where int_crednr = 2 OR int_crednr = 3') as c(int_artnr integer, supp1
float4, supp2 float4); Am I doing something wrong or is this a limitation of the
function? With kind regards, Paul |