Re: [HACKERS] MERGE vs REPLACE

2005-11-23 Thread Lyubomir Petrov
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

Re: [HACKERS] Bug 1500

2005-03-25 Thread Lyubomir Petrov
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

Re: [HACKERS] Bug 1500

2005-03-25 Thread Lyubomir Petrov
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:

[HACKERS] Bug 1500

2005-03-25 Thread Lyubomir Petrov
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