Message-ID: <4A128288.8090304@archonet.com>
Date: Tue, 19 May 2009 10:57:28 +0100
From: Richard Huxton <dev@archonet.com>
User-Agent: Thunderbird 2.0.0.21 (X11/20090320)
MIME-Version: 1.0
To: Sebastien FLAESCH <sf@4js.com>,
	PgSql General <pgsql-general@postgresql.org>
Subject: Re: INTERVAL SECOND limited to 59 seconds?
References: <4A127038.3010103@4js.com> <4A12737F.1020207@archonet.com>
	<4A127919.7080105@4js.com> <4A127C2E.1020701@archonet.com>
	<4A128178.3090508@4js.com>
In-Reply-To: <4A128178.3090508@4js.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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