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

From: Petter Reinholdtsen <pere(at)td(dot)org(dot)uit(dot)no>
To: pgsql-sql(at)postgresql(dot)org
Cc: kenrsc(at)games(dot)no
Subject: Re: [SQL] Problems with default date 'now'
Date: 1998-06-10 11:43:25
Message-ID: 199806101143.NAA11630@sleeper.games.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)td(dot)org(dot)uit(dot)no
O- <SCRIPT Language="Javascript">window.close()</SCRIPT>
http://www.hungry.com/~pere/ | Go Mozilla, go! Go!

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Herouth Maoz 1998-06-10 12:09:37 Re: [SQL] Problems with default date 'now'
Previous Message Philippe LEWEST 1998-06-10 07:31:33 Creation of a class of tables