Thanks, Tom (also Keith Worthington and Bricklen Anderson). That works.
~ Ken
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, December 14, 2005 1:15 PM
> To: Ken Winter
> Cc: PostgreSQL pg-sql list
> Subject: Re: [SQL] Defaultin
On Wed, 14 Dec 2005 13:10:50 -0500, Ken Winter wrote
> How can a column's default be set to 'now', meaning 'now' as of when each
> row is inserted?
>
> For example, here's a snip of DDL:
>
> create table personal_data (.
>
> effective_date_and_time TIMESTAMP WITH TIME ZONE not null default
> 'n
Ken Winter wrote:
How can a column’s default be set to ‘now’, meaning ‘now’ as of when
each row is inserted?
For example, here’s a snip of DDL:
create table personal_data (…
effective_date_and_time TIMESTAMP WITH TIME ZONE not null default 'now',…
try with now(), instead of now
...
"Ken Winter" <[EMAIL PROTECTED]> writes:
> How can a column's default be set to 'now', meaning 'now' as of when each
> row is inserted?
You need a function, not a literal constant. The SQL-spec way is
CURRENT_TIMESTAMP
(which is a function, despite the spec's weird idea that it should be
How can a column’s default be set to ‘now’,
meaning ‘now’ as of when each row is inserted?
For example, here’s a snip of DDL:
create table personal_data (…
effective_date_and_time TIMESTAMP WITH TIME ZONE not null
default 'now',…
The problem is, when PostgreSQL processes this D
