From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
---|---|
To: | Robert Buckley <robertdbuckley(at)yahoo(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Create loop in postgresql |
Date: | 2012-09-03 18:29:33 |
Message-ID: | 5044F70D.2000503@iol.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | salah jubeh | 2012-09-03 18:42:35 | Re: Create loop in postgresql |
Previous Message | Raymond O'Donnell | 2012-09-03 18:28:27 | Re: Create loop in postgresql |