Time format ? (Really microsecond ??)

From: "Philippe Rochat (RSR: 318 17 93)" <prochat(at)lbdsun(dot)epfl(dot)ch>
To: pgsql-sql(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Cc: postgres(at)lbdsun(dot)epfl(dot)ch
Subject: Time format ? (Really microsecond ??)
Date: 1998-10-22 10:37:35
Message-ID: 362F0AEF.839F5A17@lbdsun.epfl.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

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(dot)Rochat(at)epfl(dot)ch, http://lbdwww.epfl.ch/~prochat

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 1998-10-22 12:05:39 Re: [HACKERS] CVS Branch Tagging...
Previous Message Jan Wieck 1998-10-22 10:30:38 Re: [HACKERS] psql \d command

Browse pgsql-sql by date

  From Date Subject
Next Message ronggui 1998-10-22 13:05:47 Help me ,Thank you !!
Previous Message Jan Wieck 1998-10-22 10:04:50 Re: [SQL] `statistical' aggregate functions etc.