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 to calendar
> date/time convertor.
Currently, yes. The reason why I'm advocating for a change is:
1) I can't imagine of what use the current behavior could possibly be. Is
there anyone at all using the current output of to_char(interval)?
2) to_char() is also used for converting numeric values to strings. It is
not in some way tied to date/time from a schema perspective, although it may
be codewise.
> I think we can do with the current to_char(interval):
>
> a) maintain it as "interval" to "calendar date/time string" convertor,
> b) if nobody wants to use it as a) we can delete it from sources
> and don't waste our time with it and use our time to real
> "interval" convertor.
This sounds reasonable to me. I'll even do a survey on the SQL list to see if
anyone there is using the current behavior.
--
Josh Berkus
Aglio Database Solutions
San Francisco