Re: Timestamp Fractions Problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Florian Mader" <florian_mader(at)gmx(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Timestamp Fractions Problem
Date: 2002-09-15 14:51:42
Message-ID: 28671.1032101502@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Florian Mader" <florian_mader(at)gmx(dot)net> 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message jlparkinson 2002-09-15 21:34:15 Re: Slow Multi-joins performance [DEVELOPERS attn please]
Previous Message Florian Mader 2002-09-15 09:00:05 Re: Timestamp Fractions Problem