This explains my problem, thanks!
On Mon, Jan 3, 2011 at 7:52 PM, Jasen Betts wrote:
> On 2011-01-03, Alexander Farber wrote:
>> through some obscure error (probably on my side)
>
>> Column | Type | Modifiers
>> +---+--
On 2011-01-03, Alexander Farber wrote:
> Hello,
>
> through some obscure error (probably on my side)
> Column | Type |Modifiers
> +---+-
> id | character varying(32) |
> money | integer
Thank you Pavel, has worked:
# update pref_money as m1 set money=money+coalesce((select money from
pref_money as m2 where m1.id=m2.id and m2.yw='2011-52'),0) where
m1.yw='2010-52';
UPDATE 2081
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscript
2011/1/3 Alexander Farber :
> Hello,
>
> through some obscure error (probably on my side)
> I have several thousand entries for Jan 1 and Jan 2
> ending up in the ISO week 2011-52 instead of 2010-52
> which breaks the bar chart at the top of my script
> http://preferans.de/user.php?id=OK50489100357
Hello,
through some obscure error (probably on my side)
I have several thousand entries for Jan 1 and Jan 2
ending up in the ISO week 2011-52 instead of 2010-52
which breaks the bar chart at the top of my script
http://preferans.de/user.php?id=OK504891003571
# select * from pref_money where id='O
