Re: Merging 2 rows in a table

From: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Merging 2 rows in a table
Date: 2011-01-03 22:52:37
Message-ID: AANLkTimWSfq2tn24XVHJyrHzGQJ7ABiSEvfGEnkr+7gw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

This explains my problem, thanks!

On Mon, Jan 3, 2011 at 7:52 PM, Jasen Betts <jasen(at)xnet(dot)co(dot)nz> wrote:
> On 2011-01-03, Alexander Farber <alexander(dot)farber(at)gmail(dot)com> wrote:
>> through some obscure error (probably on my side)
>
>>  Column |         Type          |                Modifiers
>> --------+-----------------------+-----------------------------------------
>>  id     | character varying(32) |
>>  money  | integer               | not null
>>  yw     | character(7)          | default to_char(now(), 'YYYY-IW'::text)
>
> 'YYYY-IW' above should be 'IYYY-IW'

In response to

Browse pgsql-general by date

  From Date Subject
Next Message bricklen 2011-01-03 23:54:53 Re: Date Parameter To Query Confusing Optimizer
Previous Message Kurt Westerfeld 2011-01-03 22:48:36 Date Parameter To Query Confusing Optimizer