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

Re: [COMMITTERS] pgsql-server/ oc/src/sgml/datatype.sgml

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Ron Mayer <ron(at)cheapcomplexdevices(dot)com>,Ron Mayer <ron(at)intervideo(dot)com>,PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [COMMITTERS] pgsql-server/ oc/src/sgml/datatype.sgml
Date: 2004-03-30 21:52:16
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-committerspgsql-patches
Added to TODO:

   * Add GUC variable to allow output of interval values in ISO8601 format


Tom Lane wrote:
> Ron Mayer <ron(at)cheapcomplexdevices(dot)com> writes:
> >   Would formatting functions for intervals such as...
> >    to_iso8601basic_char(interval)  -- return ISO-8601 basic fmt interval
> >    to_iso8601basic_char(timestamp) -- return ISO-8601 basic fmt date/time
> >   would be better than a new GUC variable?
> I could see arguments for both --- in the timestamp world we have
> DateStyle to control the default output format, plus to_char when you
> want something different.  I'd suggest continuing with your plan of
> providing GUC control over the default interval format (just use a
> separate GUC variable, please, for orthogonality).  If you want to add
> an explicit formatting function later, you can do that too.
> BTW, I do not recall exactly why Karel wants to deprecate
> to_char(interval), but I don't think it's because of any fundamental
> objection to the notion of a formatting function.  I think it was
> because the present definition is badly designed and needs to be
> replaced with a different API.
> 			regards, tom lane
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend

  Bruce Momjian                        |
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-committers by date

Next:From: Bruce MomjianDate: 2004-03-30 21:58:20
Subject: pgsql-server/doc/src/sgml advanced.sgml dateti ...
Previous:From: Bruce MomjianDate: 2004-03-30 21:51:41
Subject: pgsql-server/doc TODO

pgsql-patches by date

Next:From: Bruce MomjianDate: 2004-03-30 21:58:26
Subject: Re: Some Documentation Changes
Previous:From: David TuroverDate: 2004-03-30 19:29:14
Subject: Building PgSQL 7.4.2 on SGI Irix 6.19

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