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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
