Received: from bastuba.partitur.se (bastuba.partitur.se [193.219.246.194]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA83160 for ; Fri, 13 Aug 1999 10:58:03 -0400 (EDT) (envelope-from kudo@partitur.se) Received: from partitur.se (tb303.partitur.se [193.219.246.230]) by bastuba.partitur.se (8.8.8/8.8.8) with ESMTP id QAA15544; Fri, 13 Aug 1999 16:57:22 +0200 (CEST) (envelope-from kudo@partitur.se) Sender: kudo@partitur.se Message-ID: <37B43252.C74A350A@partitur.se> Date: Fri, 13 Aug 1999 16:57:22 +0200 From: Patrik Kudo Organization: Partitur Informationsteknik X-Mailer: Mozilla 4.61 [en] (X11; I; FreeBSD 3.2-STABLE i386) X-Accept-Language: sv,en MIME-Version: 1.0 To: "Hutton, Rob" CC: "'pgsql-sql@postgresql.org'" Subject: Re: [SQL] Problems with default date and time References: <11EFC736FB68D111B9DD00805FAD7C6D1E0C37@plymartpdc.internal.plymart.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sorry... I couldn't get the ord_time and ord_date fields working either. =/ Will the ord_time/date/timestamp ever differ from eachother? If not, I think you'll still be able to do what you want to do even after removing the time and date fields as these can be fetched from the timestamp field. /Kudo > > -----Original Message----- > From: Hutton, Rob > Sent: Friday, August 13, 1999 10:25 AM > To: 'Patrik Kudo'; Hutton, Rob > Cc: 'pgsql-sql@postgresql.org' > Subject: RE: [SQL] Problems with default date and time > > The time and date fields are for reporting purposes while the > timestamp is for calculating elapsed time, so I need all of them. > When I make those changes, I get: > > ERROR: DEFAULT clause type 'timestamp' mismatched with column type > 'time' >