Re: [PATCHES] thousands comma numeric formatting in psql

David Fetter wrote:
> On Tue, Jul 12, 2005 at 10:48:40AM -0400, Bruce Momjian wrote:
> > Peter Eisentraut wrote:
> > > Am Dienstag, 12. Juli 2005 05:29 schrieb Bruce Momjian:
> > > > > Bruce Momjian wrote:
> > 
> > > The current state allows users to manually set the format, or
> > > actually only one aspect of the format?  Where can you set the
> > > decimal separator and the size of the grouping (3 digits or 4
> > > digits)?  Is this capability even useful to get localized
> > > behavior?
> > 
> > You can't change the grouping from three,
> 
> This makes it a non-starter, IMHO.  One set of people who use 4 digits
> is this little ethnic group called the Chinese.

I didn't know that.

> > > My other concern is that if we allow manual specification of the
> > > output format of some data type, then eventually someone will want
> > > to specify the format of some other data type as well, such as the
> > > date/time types.  We should think about whether we want to be
> > > consistent here.
> > 
> > We do allow MDY and DMY specification, but that controls both input
> > and output in the server, while this just controls psql display.  It
> > is a good question how other settings should be handled, but I don't
> > know the answers.  Anyone?
> 
> Hrm.  I think we can safely tackle input and output as separate
> features here.  What do we do for to_char() with such separators?

Well, it isn't so much the input/output issue, but that the output
control is only in psql.  Is that OK?  I don't image we could ever put
input functionality in psql, only in the server.


--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073