Re: Question about inscrutable cast syntax - Mailing list pgsql-general

From Tom Lane
Subject Re: Question about inscrutable cast syntax
Date
Msg-id 26962.1229705613@sss.pgh.pa.us
Whole thread Raw
In response to Question about inscrutable cast syntax  (Kevin Murphy <murphy@genome.chop.edu>)
List pgsql-general
Kevin Murphy <murphy@genome.chop.edu> 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 ought to do a better job of hiding that from the user...)

            regards, tom lane

pgsql-general by date:

Previous
From: Kevin Murphy
Date:
Subject: Question about inscrutable cast syntax
Next
From: Jason Long
Date:
Subject: Out of control query