Martijn,
Here is a quick test (Oracle 10.1.0.3/Linux):
SQL> select banner from v$version;
BANNER
Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Prod
PL/SQL Release 10.1.0.3.0 - Production
CORE10.1.0.3.0 Produ
Tom Lane wrote:
Lyubomir Petrov <[EMAIL PROTECTED]> writes:
I have found what is causing the crash described in Bug 1500. Now I
would like to fix it, but need opinions about what is the correct behaviour.
Yeah, I just came to the same conclusion a little while ago
eliminated. I believe that the best course of
action is to keep the to_char(interval) but restrict the available
format specifications (the textual representation specificators like
Mon/Months).
Regards,
Lyubomir Petrov
---(end of broadcast)---
TIP 7:
t to_char(now() - '20011001'::date, 'DD');
to_char
-
000112
(1 row)
test=> select now() - '20011001'::date;
?column?
---
1271 days 12:48:18.1216260046
(1 row)
So this bug actually brings the issue of interval to_char() format