to_char problem - Mailing list pgsql-sql

From postgresql
Subject to_char problem
Date
Msg-id 20020413163554.540AE475902@postgresql.org
Whole thread Raw
Responses Re: to_char problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
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




pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: deletions on master table takes for ever...
Next
From: Tom Lane
Date:
Subject: Re: to_char problem