Received: from yuubin.games.no (yuubin.link.no [193.213.36.89]) by hub.org (8.8.8/8.7.5) with ESMTP id MAA17645 for ; Tue, 9 Jun 1998 12:20:19 -0400 (EDT) Received: from sleeper.games.no (pere@sleeper.link.no [193.213.36.74]) by yuubin.games.no (8.8.7/8.8.7) with ESMTP id SAA07523; Tue, 9 Jun 1998 18:21:04 +0200 Received: (from pere@localhost) by sleeper.games.no (8.8.7/8.8.7) id SAA10905; Tue, 9 Jun 1998 18:19:49 +0200 Date: Tue, 9 Jun 1998 18:19:49 +0200 Message-Id: <199806091619.SAA10905@sleeper.games.no> To: pgsql-sql@postgresql.org Reply-to: Petter Reinholdtsen Subject: Problems with default date 'now' From: Petter Reinholdtsen Reply-to: pere@td.org.uit.no I have a table where I want the default value of a date field to be todays date when I do insert. I have this table definition: CREATE TABLE testdate( received date DEFAULT 'now', info text NOT NULL ); The problem is that the 'now' apparently is substituted when I create the table, not when I insert into it. Is there another way to handle this? This is on Linux RedHat 5.0 with PostgreSQL 6.2.1. Please remember to send replies to me (too), as I am not member on this mailing-list. Happy hacking, -- ##> Petter Reinholdtsen <## | pere@td.org.uit.no O- http://www.hungry.com/~pere/ | Go Mozilla, go! Go!