Received: from lbdsun.epfl.ch (root@lbdsun.epfl.ch [128.178.77.9]) by hub.org (8.9.1/8.8.8) with ESMTP id GAA20970; Thu, 22 Oct 1998 06:28:56 -0400 (EDT) (envelope-from prochat@lbdsun.epfl.ch) Received: from lbdsun.epfl.ch (tucana.srg-ssr.ch [146.159.4.9]) by lbdsun.epfl.ch (8.8.X/EPFL-8.1a) with ESMTP id MAA02406; Thu, 22 Oct 1998 12:28:51 +0200 (MET DST) Sender: root@lbdsun.epfl.ch Message-ID: <362F0AEF.839F5A17@lbdsun.epfl.ch> Date: Thu, 22 Oct 1998 12:37:35 +0200 From: "Philippe Rochat (RSR: 318 17 93)" Reply-To: prochat@lbdsun.epfl.ch Organization: SIRANAU X-Mailer: Mozilla 4.05 [en] (X11; I; SunOS 5.5.1 sun4m) MIME-Version: 1.0 To: pgsql-sql@postgresql.org, pgsql-hackers@postgresql.org CC: postgres@lbdsun.epfl.ch Subject: Time format ? (Really microsecond ??) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello, I'm trying to use microseconds in a field time: siranau=> create table toto ( a time ); CREATE siranau=> insert into toto values ('00:10:45.56'); INSERT 61641 1 siranau=> select * from toto; a -------- 00:10:45 (1 row) As you can see, I cannot get the microseconds value. Something more problematic is the following: % pg_dump -t toto siranau \connect - siranau CREATE TABLE toto (a time); COPY toto FROM stdin; 00:10:45 \. As you can see, microseconds values are lost ! Ph.R. -- _____________________________________________________________________ Philippe Rochat, EPFL DI-LBD Database Laboratory CH-1015 LAUSANNE Swiss Federal Institute of Technology (EPFL) tel:++41 21 693 52 53 Beep-EPFL: 181 4644 fax:++41 21 693 51 95 Private: Grammont, 9 1007 LAUSANNE tel:++41 21 617 03 05 mailto:Philippe.Rochat@epfl.ch, http://lbdwww.epfl.ch/~prochat