Re: [HACKERS] Re: [GENERAL] FM format modifier does not remove leading zero from year

2010-02-16 Thread Bruce Momjian
Applied. --- Bruce Momjian wrote: > Guy Rouillier wrote: > > On 1/6/2010 3:29 PM, Tom Lane wrote: > > > Guy Rouillier writes: > > >> Oracle states clearly in the SQL Reference manual: > > > > > >> "A modifier can appear in

Re: [HACKERS] Re: [GENERAL] FM format modifier does not remove leading zero from year

2010-02-08 Thread Bruce Momjian
Tom Lane wrote: > Alvaro Herrera writes: > > What's the point of not following Oracle here, since this is solely an > > Oracle compatibility function? > > Changing FM's behavior like that will break approximately every user > of to_char() ... I would love to know why we are finding out about thi

Re: [HACKERS] Re: [GENERAL] FM format modifier does not remove leading zero from year

2010-02-08 Thread Tom Lane
Alvaro Herrera writes: > What's the point of not following Oracle here, since this is solely an > Oracle compatibility function? Changing FM's behavior like that will break approximately every user of to_char() ... regards, tom lane -- Sent via pgsql-hackers mailing lis

Re: [HACKERS] Re: [GENERAL] FM format modifier does not remove leading zero from year

2010-02-08 Thread Alvaro Herrera
Bruce Momjian wrote: > Guy Rouillier wrote: > > On 1/6/2010 3:29 PM, Tom Lane wrote: > > > Guy Rouillier writes: > > >> Oracle states clearly in the SQL Reference manual: > > > > > >> "A modifier can appear in a format model more than once. In such a case, > > >> each subsequent occurrence toggles

[HACKERS] Re: [GENERAL] FM format modifier does not remove leading zero from year

2010-02-06 Thread Bruce Momjian
Guy Rouillier wrote: > On 1/6/2010 3:29 PM, Tom Lane wrote: > > Guy Rouillier writes: > >> Oracle states clearly in the SQL Reference manual: > > > >> "A modifier can appear in a format model more than once. In such a case, > >> each subsequent occurrence toggles the effects of the modifier." > >