Re: Nested select

Поиск
Список
Период
Сортировка
От Aaron Bono
Тема Re: Nested select
Дата
Msg-id bf05e51c0611070640q15f4b519jf6ababf5c439f1b0@mail.gmail.com
обсуждение исходный текст
Ответ на Nested select  (Hubert Retif <hubert.retif@i-netsoft.ch>)
Список pgsql-sql
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.com
   http://codeelixir.com
==================================================================

В списке pgsql-sql по дате отправления:

Предыдущее
От: "Jonah H. Harris"
Дата:
Сообщение: Re: writing a simple sql parser and database program
Следующее
От: "Aaron Bono"
Дата:
Сообщение: Re: Distribution of results