Received: from s20.highertech.net (root@s20.highertech.net [209.54.120.20]) by hub.org (8.9.3/8.9.3) with ESMTP id IAA77212 for ; Tue, 13 Jul 1999 08:39:42 -0400 (EDT) (envelope-from jt-kirkpatrick@mpsllc.com) Received: from kirkpatrickjt (whiteoak-34.highertech.net [209.140.56.34] (may be forged)) by s20.highertech.net (8.8.6/8.8.6) with SMTP id IAA18431; Tue, 13 Jul 1999 08:38:58 -0400 Received: by localhost with Microsoft MAPI; Tue, 13 Jul 1999 08:39:51 -0400 Message-ID: <01BECD0B.45F87E00.jt-kirkpatrick@mpsllc.com> From: JT Kirkpatrick To: "'nmmm@nsi.bg'" Cc: "'pgsql-sql@hub.org'" Subject: Date: Tue, 13 Jul 1999 08:39:50 -0400 Organization: MPS, LLC X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit niki -- in the creation of your table, use ->dt datetime default text 'now' i had the same problem as you and this cured it. . . i believe also it works with the other data types. . . jt kirkpatrick ++++++++++++++ Date: Mon, 12 Jul 1999 11:21:02 +0300 From: "Nikolay Mijaylov" Subject: Stupid question about default time value I made a table such as: create teble x( i int2, d date default 'today', t time default 'now', dt datetime default 'now' ); So these default values are not working as i think... they make the default values to be equal to time when table was created.... i fixed problem in this way: create teble x( i int2, d date default date( now() ), // or now() :: date t time default datetime_time(datetime (now ()) ), dt datetime default now() ); is there better way to do this????? Niki w3.nsi.bg/nmmm www.nsi.bg/nmmm nmmm.hypermart.net ????? thanx ------------------------------