current_timestamp without TZ in CREATE table - Mailing list pgsql-general

From Jean-Christian Imbeault
Subject current_timestamp without TZ in CREATE table
Date
Msg-id 3DFECC78.5080108@mega-bucks.co.jp
Whole thread Raw
Responses Re: current_timestamp without TZ in CREATE table  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I get the following error while trying to create a table:

JC=# create table test (t timestamp[0] default current_timestamp(0));
ERROR:  Column "t" is of type timestamp without time zone[] but default
expression is of type timestamp with time zone You will need to rewrite
or cast the expression

What is the proper syntax to declare the default to be without time zone?

Thanks,

JC


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: How to access deleted but not vacuum'ed tuples?
Next
From: Tom Lane
Date:
Subject: Re: current_timestamp without TZ in CREATE table