Postgres Pro
Downloads
Home   >   mailing lists

Re: Merging 2 rows in a table - Mailing list pgsql-general

From Alexander Farber
Subject Re: Merging 2 rows in a table
Date
Msg-id AANLkTimh80fxjnEoPCzgOq3h0PEocPsGJEwa++KbP=bU@mail.gmail.com
Whole thread Raw
In response to Re: Merging 2 rows in a table  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Merging 2 rows in a table
Next
From: Jeremy Harris
Date:
Subject: Re: problem updating from form