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
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
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
_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
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
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
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
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
_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
; sum(ges_kw_zgb) From energie.tennet_auswertung_2010)),2) ..
>
> Regards
>
>
>
> *From:* Robert Buckley
> *To:* "pgsql-general@postgresql.org"
> *Sent:* Monday, September 3, 2012 5:30 PM
> *Subject:* [GENERAL] Create loop in postgresql
>
> Hi,
>
>
...
>
> Regards
>
>
>
> *From:* Robert Buckley
> *To:* "pgsql-general@postgresql.org"
> *Sent:* Monday, September 3, 2012 5:30 PM
> *Subject:* [GENERAL] Create loop in postgresql
>
> Hi,
>
> I am trying to loop through the rec
ot;
Sent: Monday, September 3, 2012 5:30 PM
Subject: [GENERAL] Create loop in postgresql
Hi,
I am trying to loop through the records in a table and update a column. I can
do this with a case statement but I would like to simplify this to a simple
loop statement. I can´t seem to work out how to do
Hi,
I am trying to loop through the records in a table and update a column. I can
do this with a case statement but I would like to simplify this to a simple
loop statement. I can´t seem to work out how to do it though.
Here is the case statement.
select name,ges_kw_zgb,
case
When name='Bad Ha
13 matches
Mail list logo
