Thread: to_char problem

Can some one explain this result. Notice the select.... the result 
shows the month followed by 5 spaces and then the comma one 
space and the year. 

Why are there 5 spaces (ascii 32) after the month? I  get the same 
thing if I say  'MonthDD, YYYY'. That is no space after the month.

Is this is operating as expected and my expectations are wrong, 
point me to the manual pages that explain it.

Mac OSX 10.1.2 postgresql 7.2.1

fifthcolor=# select to_char(termdate, 'Month DD, YYYY') from 
employees where code = 'MM';     to_char       
--------------------April     09, 2002
(1 row)

Ted

"postgresql" <pgsql@symcom.com> writes:
> Why are there 5 spaces (ascii 32) after the month?

Fixed-width output column (think "September").  Use FM prefix if you
don't want the extra space.

Yeah, it's an ugly formatting language :-(.  I think Oracle gets the
blame here...
        regards, tom lane