Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 97438475BC3 for ; Mon, 16 Sep 2002 04:30:03 -0400 (EDT) Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id E24B9475AD7 for ; Mon, 16 Sep 2002 04:30:01 -0400 (EDT) Received: (qmail 18152 invoked by uid 0); 16 Sep 2002 08:30:02 -0000 Received: from chello080110012194.202.12.wu-wien.teleweb.at (HELO FPCm) (80.110.12.194) by mail.gmx.net (mp001-rz3) with SMTP; 16 Sep 2002 08:30:02 -0000 From: "Florian Mader" To: Subject: Re: Timestamp Fractions Problem Date: Mon, 16 Sep 2002 10:29:13 +0200 Message-ID: <000001c25d5b$241aabd0$0300a8c0@FPCm> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 Importance: Normal In-Reply-To: <28671.1032101502@sss.pgh.pa.us> X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/154 X-Sequence-Number: 9431 I am using: PostgreSQL 7.2.2 ODBC Driver 7.02.00.02 Cygwin 1.3.12-2 Win2000 5.00.2195 SP2 WinSQL 3.8.19.499 I don't think that there's a problem with my versions. Do you have any other idea? TIA -----Urspr=FCngliche Nachricht----- Von: Tom Lane [mailto:tgl@sss.pgh.pa.us]=20 Gesendet: Sonntag, 15. September 2002 16:52 An: Florian Mader Cc: pgsql-sql@postgresql.org Betreff: Re: [SQL] Timestamp Fractions Problem=20 "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