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