Re: [GENERAL] Question about inscrutable cast syntax

2008-12-19 Thread Tom Lane
Kevin Murphy writes: > lastupdated timestamp without time zone DEFAULT > ('now'::text)::timestamp(6) with time zone NOT NULL > For my personal edification, I'd like to understand what's going on with > that first one! It's what the PG grammar converts CURRENT_TIMESTAMP(6) into. (We really oug

[GENERAL] Question about inscrutable cast syntax

2008-12-19 Thread Kevin Murphy
Two versions of an application differ in the way a particular column is defined. OLD: lastupdated timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL NEW: lastupdated timestamp without time zone DEFAULT now() NOT NULL I believe these are both the result