From: Michael Fuhr <mike@fuhr.org>
To: Leendert Paul Diterwich <paul@winaskon.nl>
Cc: pgsql-sql@postgresql.org
Subject: Re: Crosstab question
Date: Sun, 22 Oct 2006 09:45:56 -0600
Message-ID: <20061022154556.GA29357@winnie.fuhr.org> (raw)
In-Reply-To: <453b5c95.3a026987.2aae.ffffb959@mx.google.com>
References: <453b5c95.3a026987.2aae.ffffb959@mx.google.com>
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.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);
Try using the crosstab(text source_sql, text category_sql) variant.
Unrelated suggestion: prices should probably be numeric instead of
floating-point due to the inexactness of the latter.
--
Michael Fuhr
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mike@fuhr.org, paul@winaskon.nl
Subject: Re: Crosstab question
In-Reply-To: <20061022154556.GA29357@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox