Re: Interval support for Postgres

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: Oliver Siegmar <o(dot)siegmar(at)vitrado(dot)de>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Interval support for Postgres
Date: 2005-04-21 21:47:03
Message-ID: 42681F57.4080308@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Kris Jurka wrote:

> 1) You have an "int milliseconds" field. PG supports microsecond
> precision in intervals. Is there any reason not to go with a plain "float
> seconds" field instead of splitting these up?

Can you represent all of 0.000000 .. 59.999999 exactly as floats?

-O

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dennis Sacks 2005-04-21 21:59:11 Re: switching from 7.4.1 to 8.0-311 jdbc driver
Previous Message Oliver Jowett 2005-04-21 21:37:44 Re: Array support