[GENERAL] problem with round() in php script

[Robert Buckley]

hi,

In pgadmin3 this query works ok.

SELECT name,round(ges_kw,0)
FROM energie.tennet_auswertung_2010;

but in php 5.3.2 the result is 0 for all rows

$result = pg_query('
SELECT name,round(ges_kw,0)
FROM energie.tennet_auswertung_2010
');


What should I do to round up to 0 decimal places?

yours with thanks,

Rob