Re: ISO 8601 "Time Intervals" of the "format with time-unit deignators"

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Ron Mayer" <ron@intervideo.com>
Cc: pgsql-patches@postgresql.org
Date: 2003-09-08T05:47:17Z
Lists: pgsql-hackers
"Ron Mayer" <ron@intervideo.com> writes:
>    Compared to the ISO 8601 time interval specification, the
>    postgresql interval syntax is quite verbose.  For example:

>      Postgresql interval:              ISO8601 Interval
>      ---------------------------------------------------
>      '1 year 6 months'                'P1Y6M'
>      '3 hours 25 minutes 42 seconds'  'PT3H25M42S'

Er, don't we support that already?  I know I saw code to support
something much like that syntax last time I looked into the datetime
routines.

			regards, tom lane