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 AANLkTimWSfq2tn24XVHJyrHzGQJ7ABiSEvfGEnkr+7gw@mail.gmail.com
Whole thread Raw
In response to Re: Merging 2 rows in a table  (Jasen Betts <jasen@xnet.co.nz>)
List pgsql-general
This explains my problem, thanks!

On Mon, Jan 3, 2011 at 7:52 PM, Jasen Betts <jasen@xnet.co.nz> wrote:
> On 2011-01-03, Alexander Farber <alexander.farber@gmail.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'

pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Merging 2 rows in a table
Next
From: "Kurt Westerfeld"
Date:
Subject: Date Parameter To Query Confusing Optimizer