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@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
