Can you write the error message here? --Imad www.EnterpriseDB.com
On 11/6/06, Hubert Retif <[EMAIL PROTECTED]> wrote:
Hi, 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 Has someone a solution for that situation? Thanks, Hubert Retif
---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
