From: Aaron Bono <postgresql@aranya.com>
To: hubert.retif@i-netsoft.ch
Cc: pgsql-sql@postgresql.org
Subject: Re: Nested select
Date: Tue, 7 Nov 2006 08:40:38 -0600
Message-ID: <bf05e51c0611070640q15f4b519jf6ababf5c439f1b0@mail.gmail.com> (raw)
In-Reply-To: <200611061136.kA6BahZc012041@saturn11.saturn11.de>
References: <200611061136.kA6BahZc012041@saturn11.saturn11.de>
On 11/6/06, Hubert Retif <hubert.retif@i-netsoft.ch> wrote:
>
> I am migrating my application from MySQL to Postgresql and have met
> following situation:
>
>
>
> SELECT
>
> (sum(sold_price)/(select sum(sold_price) from car_archive))*100 as
> CA_pcent,
>
> reason_text
>
> FROM car_archive
>
> group by reason_text
>
> order by CA_pcent desc
>
>
>
> works perfectly in MySQL, but not in Postgresql. The problem seems to be
> the nested select which should deliver a sum of the whole table, but it does
> not.
>
>
>
> If I replace this nested select with a fix value, then it works:
>
>
>
> SELECT
>
> (sum(sold_price)/(333))*100 as CA_pcent,
>
> reason_text
>
> FROM car_archive
>
> group by reason_text
>
> order by CA_pcent desc
>
Are you suffering from round off error? That is the only thing I can think
of from what you have said.
What happens if you cast the price to a real or double precision?
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.comhttp://codeelixir.com
==================================================================
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: postgresql@aranya.com, hubert.retif@i-netsoft.ch
Subject: Re: Nested select
In-Reply-To: <bf05e51c0611070640q15f4b519jf6ababf5c439f1b0@mail.gmail.com>
* 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