Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 344924762D1 for ; Sun, 15 Sep 2002 10:52:03 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 89A324762CC for ; Sun, 15 Sep 2002 10:52:02 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id g8FEpg5D028672; Sun, 15 Sep 2002 10:51:42 -0400 (EDT) To: "Florian Mader" Cc: pgsql-sql@postgresql.org Subject: Re: Timestamp Fractions Problem In-reply-to: <000301c25c96$4a4375a0$0300a8c0@FPCm> References: <000301c25c96$4a4375a0$0300a8c0@FPCm> Comments: In-reply-to "Florian Mader" message dated "Sun, 15 Sep 2002 11:00:05 +0200" Date: Sun, 15 Sep 2002 10:51:42 -0400 Message-ID: <28671.1032101502@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/152 X-Sequence-Number: 9429 "Florian Mader" writes: > Now I tried the same create, insert and select statement you did. But > the DB didn't return fractions like it did in your case. Hm, what PG version are you running? You need 7.2 or later to have full support for fractional timestamps (in particular, the result of now() is only good to the nearest second in prior versions). regards, tom lane