Re: Create loop in postgresql

On 03/09/2012 18:42, Robert Buckley wrote:
> This works ok
> SELECT round(100 * (ges_kw_zgb / (select sum(ges_kw_zgb) From
> energie.tennet_auswertung_2010)),2) FROM energie.tennet_auswertung_2010
>
> but this does not
>
> update energie.tennet_auswertung_2010 set "Test"=
> (
> SELECT round(100 * (ges_kw_zgb / (select sum(ges_kw_zgb) From
> energie.tennet_auswertung_2010)),2) FROM energie.tennet_auswertung_2010
> );
>
> ?????????

Define "works". What do you expect to get, and what so you actually get?
We can't read your mind. :-)

Also, please don't top-post - thanks.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie