FM format modifier does not removeleading zero from year
in [PgSql]
|
Prev: [HACKERS] Streaming replication in docs
Next: FM format modifier does not remove leading zero from year
From: Alvaro Herrera on 8 Feb 2010 11:07 Bruce Momjian wrote: > Guy Rouillier wrote: > > On 1/6/2010 3:29 PM, Tom Lane wrote: > > > Guy Rouillier<guyr-ml1(a)burntmail.com> 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." > > > > > > *Toggles* the effect of the modifier? Egad, what drunken idiot chose > > > that specification? > > > > Eh, tomato, tomahto. If you assume that someone will strip leading > > zeroes consistently, the Oracle approach makes sense. That would be a > > reasonable assumption to make; why would I strip the zero off the month > > but leave it on the day? So, in the unusual case that you want to do > > such a thing, you are asked to use a second occurrence of FM to turn > > zero suppression back off. > > I have developed the attached patch which implements FM control of YYY, > YY, and Y specifications. I also documented that we do not match > Oracle's toggle behavior. There are a few effects on regression test > output which are part of this patch. What's the point of not following Oracle here, since this is solely an Oracle compatibility function? -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers |