Re: Interval support for Postgres - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Interval support for Postgres
Date
Msg-id 42681F57.4080308@opencloud.com
Whole thread Raw
In response to Re: Interval support for Postgres  (Kris Jurka <books@ejurka.com>)
Responses representing (seconds + microseconds) as floats [was:Re: Interval support for Postgres]
List 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

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Array support
Next
From: Dennis Sacks
Date:
Subject: Re: switching from 7.4.1 to 8.0-311 jdbc driver