Received: from hipernet.com.br ([200.246.90.107]) by hub.org (8.9.2/8.9.1) with ESMTP id OAA07447 for ; Tue, 23 Mar 1999 14:01:19 -0500 (EST) (envelope-from roberto@mha.com.br) Received: from pc35.mha.com.br ([200.245.167.70]) by hipernet.com.br (8.8.8+Sun/8.8.8) with SMTP id QAA23652 for ; Tue, 23 Mar 1999 16:01:08 -0300 (EST) Message-Id: <3.0.5.32.19990323155824.007fa8c0@pop.hipernet.com.br> X-Sender: roberto@pop.hipernet.com.br X-Mailer: QUALCOMM Windows Eudora Light Version 3.0.5 (32) Date: Tue, 23 Mar 1999 15:58:24 -0300 To: pgsql-sql@postgreSQL.org From: Roberto Joao Lopes Garcia Subject: DEFAULT TEXT 'now' Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id OAA07463 Hi I´m have a table like bellow: CREATE TABLE conex ( id int4 PRIMARY KEY DEFAULT NEXTVAL('seq_conex'), inicio datetime DEFAULT TEXT 'now', ultimo datetime DEFAULT TEXT 'now', . . . ) insert into conex (ip) values(´200.200.200.200´) Will result every time the same data and time for ´inicio´ and ´ultimo´! I want to insert the current date and time. Is that code correct and the result a bug??? Is there an way to make the DEFAULT work??? I know I can insert like: insert into conex (ip, inicio, ultimo) values(´200.200.200.200´, ´now´, ´now´) but I would like to use DEFAULT. PostgreSQL 6.4 - Solaris 2.5 sparc Thank you Roberto