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
-
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() formatting.
Opinions?
Regards,
Lyubomir Petrov
---(end of broadcast
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: don't forget to increase your free
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:
http
