Skip site navigation (1) Skip section navigation (2)

Re: Re: Updated interval patches (SQL std output, ISO8601 intervals, and interval rounding)

From: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Re: Updated interval patches (SQL std output, ISO8601 intervals, and interval rounding)
Date: 2008-11-01 00:30:58
Message-ID: 490BA342.7010300@cheapcomplexdevices.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Ron Mayer wrote:
> Ron Mayer wrote:
>  > Tom Lane wrote:
>  >> In fact, given that we are now
>  >> somewhat SQL-compliant on interval input, a GUC that selected
>  >> PG traditional, SQL-standard, or ISO 8601 interval output format seems
>  >> like it could be a good idea.
> 
> Attached are updated versions of the Interval patches ...


# Patch 2:
    ISO 8601 Formatted Interval Input and Output

    This patch adds another IntervalStyle 'iso_8601' to output ISO 8601
    Time Intervals of the "format with designators". These are a bit
    more flexible than Sql Standard intervals in that (like postgres)
    they can express both years and days in the same interval value.

    Reason for the patch:SQL Standard Intervals are limited compared to
    postgres in what they allow (no mixed year-month and day-time
    components). ISO8601 intervals allow such intervals and are easier
    for machines to parse than the traditional postgres formats.

    This patch depends on the IntervalStyle patch mentioned above.

Attachment: 2_iso8601interval.patch
Description: text/x-diff (16.5 KB)

In response to

Responses

pgsql-hackers by date

Next:From: KaiGai KoheiDate: 2008-11-01 00:47:25
Subject: Re: Please make sure your patches are on the wiki page
Previous:From: Ron MayerDate: 2008-11-01 00:22:55
Subject: Re: Updated interval patches (SQL std output, ISO8601 intervals, and interval rounding)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group