Postgres Pro
Downloads
Home   >   mailing lists

Re: to_char problem - Mailing list pgsql-sql

From Tom Lane
Subject Re: to_char problem
Date
Msg-id 16338.1018717238@sss.pgh.pa.us
Whole thread Raw
In response to to_char problem  ("postgresql" <pgsql@symcom.com>)
List pgsql-sql
Tree view 
"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

pgsql-sql by date:

Previous
From: "postgresql"
Date:
Subject: to_char problem
Next
From: "jack"
Date:
Subject: data order problem