Hi,
Thanks a lot,
That exactly wat I need
:)
Suad
Chris wrote:
suad wrote:
Hi,
I need some help in sql - postgresql:
<snip>
Yay a postgres question! :D hee hee
*The question is* : how can I force that the result of the col payed
to be zerro "0" insted of nothing (NULL)
and the order will be in way that the zerro's values comes first.
and the result will be:
sum | payed | to_pay
-----+-------+--------
25 | 0 | 0
150 | 150 | 0
175 | 150 | 25
COALESCE will do it for you:
SELECT SUM(c_price) as sum,(SELECT COALESCE(SUM(d_price), 0) FROM d
WHERE a_id=t1.a_id ) AS payed, SUM(c_price)-(SELECT
COALESCE(SUM(d_price), 0) FROM d WHERE a_id=t1.a_id ) AS to_pay FROM c
AS t1 group by a_id order by payed;
sum | payed | to_pay
-----+-------+--------
25 | 0 | 25
150 | 150 | 0
175 | 150 | 25
(3 rows)
http://www.postgresql.org/docs/8.1/interactive/functions-conditional.html
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
