Re: [GENERAL] Create loop in postgresql

2012-09-03 Thread Raymond O'Donnell
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

Re: [GENERAL] Create loop in postgresql

2012-09-03 Thread salah jubeh
t;pgsql-general@postgresql.org" Sent: Monday, September 3, 2012 7:30 PM Subject: Re: [GENERAL] Create loop in postgresql Now even stranger is that I can´t update a column with the query. Update energie.tennet_auswertung_2010 set "Test"=( SELECT round(100*ges_kw_zgb/total.totalsum, 2) from

Re: [GENERAL] Create loop in postgresql

2012-09-03 Thread Raymond O'Donnell
On 03/09/2012 18:30, Robert Buckley wrote: > Now even stranger is that I can´t update a column with the query. > > Update energie.tennet_auswertung_2010 set "Test"=( > > SELECT round(100*ges_kw_zgb/total.totalsum, 2) from > energie.tennet_auswertung_2010, > (select sum(ges_kw_zgb) totalsum From

Re: [GENERAL] Create loop in postgresql

2012-09-03 Thread Robert Buckley
_zgb) From energie.tennet_auswertung_2010)),2) FROM energie.tennet_auswertung_2010 ); ? Von: Robert Buckley An: salah jubeh ; "pgsql-general@postgresql.org" Gesendet: 19:30 Montag, 3.September 2012 Betreff: Re: [GENERAL] Create loop in postgresql

Re: [GENERAL] Create loop in postgresql

2012-09-03 Thread Robert Buckley
w_zgb) totalsum From energie.tennet_auswertung_2010) as total; How would I update the rows? Cheers for any help, Rob Von: salah jubeh An: Robert Buckley ; "pgsql-general@postgresql.org" Gesendet: 18:23 Montag, 3.September 2012 Betreff: Re: [GENERAL] Create loop

Re: [GENERAL] Create loop in postgresql

2012-09-03 Thread Robert Buckley
Thanksthat worked a treat! cheers, Rob Von: salah jubeh An: Robert Buckley ; "pgsql-general@postgresql.org" Gesendet: 18:23 Montag, 3.September 2012 Betreff: Re: [GENERAL] Create loop in postgresql Hello Robert, I just gave an example and

Re: [GENERAL] Create loop in postgresql

2012-09-03 Thread Raymond O'Donnell
On 03/09/2012 17:06, Robert Buckley wrote: > this give an error. > > select name,ges_kw_zgb, SELECT round(100 * (ges_kw_zgb / (select > sum(ges_kw_zgb) From energie.tennet_auswertung_2010)),2); > > ERROR: syntax error at or near "SELECT" LINE 2: select > name,ges_kw_zgb, SELECT round(100 * (ges

Re: [GENERAL] Create loop in postgresql

2012-09-03 Thread salah jubeh
3, 2012 6:06 PM Subject: Re: [GENERAL] Create loop in postgresql this give an error. select name,ges_kw_zgb, SELECT round(100 * (ges_kw_zgb / (select sum(ges_kw_zgb) From energie.tennet_auswertung_2010)),2); ERROR:  syntax error at or near "SELECT" LINE 2: select name,ges_kw_z

Re: [GENERAL] Create loop in postgresql

2012-09-03 Thread Robert Buckley
_zgb / (se... Von: salah jubeh An: Robert Buckley ; "pgsql-general@postgresql.org" Gesendet: 17:45 Montag, 3.September 2012 Betreff: Re: [GENERAL] Create loop in postgresql I am wondering why do not you write it like this select name,ges_kw_zgb, select round(100 * (ges_kw_zgb / (se

Re: [GENERAL] Create loop in postgresql

2012-09-03 Thread Rainer Pruy
:* 17:45 Montag, 3.September 2012 > *Betreff:* Re: [GENERAL] Create loop in postgresql > > I am wondering why do not you write it like this > > select name,ges_kw_zgb, select round(100 * (ges_kw_zgb / (select >

Re: [GENERAL] Create loop in postgresql

2012-09-03 Thread Rainer Pruy
And probably the op would prefer to avoid recalculating the sum once for every row. select name,ges_kw_zgb, round(100*ges_kw_zgb/total.totalsum, 2) as z from energie.tennet_auswertung_2010, (select sum(ges_kw_zgb) totalsum >From energie.tennet_auswertung_2010) as total where .. Regards R

Re: [GENERAL] Create loop in postgresql

2012-09-03 Thread salah jubeh
I am wondering why do not you write it like this select name,ges_kw_zgb, select round(100 * (ges_kw_zgb / (select sum(ges_kw_zgb) From energie.tennet_auswertung_2010)),2) .. Regards From: Robert Buckley To: "pgsql-general@postgresql.org" Sent: Mond