This explains my problem, thanks! On Mon, Jan 3, 2011 at 7:52 PM, Jasen Betts <jasen@xxxxxxxxxx> wrote: > On 2011-01-03, Alexander Farber <alexander.farber@xxxxxxxxx> 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' -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general