Re: INTERVAL SECOND limited to 59 seconds?

Sebastien FLAESCH wrote:
> 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

Well, it's not storage it's formatting. Doesn't make any difference to
your problem though.

 >, 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...

If you know a little "C" you could build some custom types to match your
needs. It should just be a matter of applying the correct formatting as
a wrapper around the existing "interval" type.

--
   Richard Huxton
   Archonet Ltd