Re: [SQL] Problems with default date 'now' - Mailing list pgsql-sql

From Petter Reinholdtsen
Subject Re: [SQL] Problems with default date 'now'
Date
Msg-id 199806101143.NAA11630@sleeper.games.no
Whole thread Raw
Responses Re: [SQL] Problems with default date 'now'  (Herouth Maoz <herouth@oumail.openu.ac.il>)
List 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!


pgsql-sql by date:

Previous
From: "Jose' Soares Da Silva"
Date:
Subject: Re: [SQL] Problems with default date 'now'
Next
From: Herouth Maoz
Date:
Subject: Re: [SQL] Problems with default date 'now'