distinct doesn't work

From: stephen
Subject: distinct doesn't work
Date: ,
Msg-id: 000001c7bfe8$902f10f0$cd0b690a@tablet
(view: Whole thread, Raw)
Responses: Re: distinct doesn't work  (Viatcheslav Kalinin)
Re: distinct doesn't work  (Frank Bax)
List: pgsql-novice

Hi

 

I am doing this:

 

SELECT distinct cc.trader_id, t.credit_card_number, t.expiry_date, t.name_on_card, sum(to_number(cc.debit_credit,'999999.99')),cc.approval_number, t.business_name  FROM credit_card_history AS cc INNER JOIN traders AS t USING (trader_id) GROUP by cc.trader_id, t.credit_card_number, t.expiry_date, t.name_on_card, cc.approval_number, t.business_name having sum(to_number(cc.debit_credit,'999999.99')) != 0

 

And I expect to get one line as I only have I trader-id in my table(s) but I get this:

 

1493 4321442143314432 09/09 two duck -200  2 Duck Trading Company

1493 4321442143314432 09/09 two duck 200 5678 2 Duck Trading Company

 

In fact I don’t actually expect to get any response as the sum should have summed to zero.

 

Does anyone know what I am doing wrong?

 

Stephen Choularton

0413 545 182

02 9999 2226

 


pgsql-novice by date:

From: Viatcheslav Kalinin
Date:
Subject: Re: distinct doesn't work
From: "Doug Johnson"
Date:
Subject: 8.2 RETURNING functionality in a trigger