Re: INTERVAL SECOND limited to 59 seconds? - Mailing list pgsql-general

From Sebastien FLAESCH
Subject Re: INTERVAL SECOND limited to 59 seconds?
Date
Msg-id 4A1281A7.7010000@4js.com
Whole thread Raw
In response to Re: INTERVAL SECOND limited to 59 seconds?  (Richard Huxton <dev@archonet.com>)
Responses Re: INTERVAL SECOND limited to 59 seconds?  (Scott Bailey <artacus@comcast.net>)
List pgsql-general
Actually it's not limited to the usage of INTERVAL SECOND, I am writing
a PostgreSQL driver for our 4GL virtual machine...

I need to store all possible Informix INTERVAL types such as:

    INTERVAL MONTH(8) TO MONTH
    INTERVAL DAY(8) TO MINUTE
    INTERVAL SECOND TO FRACTION(5)
    ... etc ...

...

If PostgreSQL is not able to store months > 11, hours > 23 and minutes
or seconds > 59, it looks like I will need to deal with PostgreSQL's

    INTERVAL YEAR TO MONTH
    INTERVAL DAY TO SECOND(5)

... and make conversions, to store all possible Informix INTERVALs...

Seb


pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: INTERVAL SECOND limited to 59 seconds?
Next
From: Richard Huxton
Date:
Subject: Re: INTERVAL SECOND limited to 59 seconds?