Re: [HACKERS] to_char(interval) --- done?

2003-03-26 Thread Larry Rosenman
--On Wednesday, March 26, 2003 08:50:36 -0800 Josh Berkus <[EMAIL PROTECTED]> wrote: Larry, I had a need that should(!) be in the archives. Just to reiterate my need: I input a contract length, in months, and wanted to get it back out as months. There is no current way to do this, so I store

Re: [HACKERS] to_char(interval) --- done?

2003-03-26 Thread Josh Berkus
Larry, > I had a need that should(!) be in the archives. Just to reiterate my need: > > I input a contract length, in months, and wanted to get it back out as > months. There is no current way to do this, so I store it as an INT and > concatenate the word months to do the > date arithmetic. Wha

Re: [HACKERS] to_char(interval) --- done?

2003-03-26 Thread Larry Rosenman
--On Wednesday, March 26, 2003 08:38:58 -0800 Josh Berkus <[EMAIL PROTECTED]> wrote: Karel, IMHO nobody use it -- maybe we can keep it in sources for 7.4 and mark it in docs as deprecated and remove it in 7.5. This seems to be consistent with my informal survey on PGSQL-SQL and on # postgres

Re: [HACKERS] to_char(interval) --- done?

2003-03-26 Thread Josh Berkus
Karel, > IMHO nobody use it -- maybe we can keep it in sources for 7.4 and > mark it in docs as deprecated and remove it in 7.5. This seems to be consistent with my informal survey on PGSQL-SQL and on #postgresql. Nobody seems to be using the current behavior. > The date/time and numbers f

Re: [HACKERS] to_char(interval) --- done?

2003-03-25 Thread Josh Berkus
Karel, > If I see this I must agree with Peter that to_char() is something > other than "interval" to "interval-as-string" convertor. The current > code use date/time as complex of date/time information _based_ on > calendar practice -- > The other words: current to_char(interval) is interval

Re: [HACKERS] to_char(interval) --- done?

2003-03-24 Thread Karel Zak
On Mon, Mar 24, 2003 at 09:56:53AM -0400, Alvaro Herrera wrote: > > I volunteered to look into it, but got a sorta negative reply from Peter_E, > > but no > > response to my request for suggestions. > > I think what Peter was saying is to research some ways to manage > intervals and other time re

Re: [HACKERS] to_char(interval) --- done?

2003-03-24 Thread Alvaro Herrera
On Mon, Mar 24, 2003 at 04:34:38AM -0600, Larry Rosenman wrote: > > > --On Monday, March 24, 2003 09:40:46 +0100 Karel Zak <[EMAIL PROTECTED]> > wrote: > > >On Fri, Mar 21, 2003 at 03:32:11PM -0800, Josh Berkus wrote: > >>Folks, > >> > >>Some months ago we agreed on this list that the functioni

Re: [HACKERS] to_char(interval) --- done?

2003-03-24 Thread Karel Zak
On Fri, Mar 21, 2003 at 03:32:11PM -0800, Josh Berkus wrote: > Folks, > > Some months ago we agreed on this list that the functioning of > to_char(interval) was not particularly useful the way it works in current > stable versions. I don't see a to_char fix on the TODO list, though; does > th