| From: | Sebastien FLAESCH <sf(at)4js(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: INTERVAL SECOND limited to 59 seconds? |
| Date: | 2009-05-19 09:53:43 |
| Message-ID: | 4A1281A7.7010000@4js.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2009-05-19 09:57:28 | Re: INTERVAL SECOND limited to 59 seconds? |
| Previous Message | Richard Huxton | 2009-05-19 09:30:22 | Re: INTERVAL SECOND limited to 59 seconds? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2009-05-19 09:57:28 | Re: INTERVAL SECOND limited to 59 seconds? |
| Previous Message | Richard Huxton | 2009-05-19 09:30:22 | Re: INTERVAL SECOND limited to 59 seconds? |