Horton

Re: [SQL] Problems with default date 'now'

Petter Reinholdtsen <pere@td.org.uit.no>

View thread View on postgr.es
From: Petter Reinholdtsen <pere@td.org.uit.no>
To: pgsql-sql@postgresql.org
Cc: kenrsc@games.no
Date: 1998-06-10T11:43:25Z
Lists: pgsql-sql 
> replace your field definition with this one: 
> 
> received_date DATE DEFAULT CURRENT_DATE
> 
> it works fine.

Nope, that did not work.

I get this reply from psql:

  WARN:parser: parse error at or near "current_date"

What is wrong.  Is this something new in PostgreSQL after v6.2.1?

I don't follow the SQL mailinglist, so please send me a copy when you
reply.
-- 
##>  Petter Reinholdtsen <##    | pere@td.org.uit.no
 O-  <SCRIPT Language="Javascript">window.close()</SCRIPT>
http://www.hungry.com/~pere/    | Go Mozilla, go! Go!