Re: current_timestamp without TZ in CREATE table

Jean-Christian Imbeault <jc@mega-bucks.co.jp> writes:
> 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

Square brackets mean an array.  I think you meant timestamp(0).

            regards, tom lane