Re: [PATCHES] thousands comma numeric formatting in psql - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [PATCHES] thousands comma numeric formatting in psql
Date
Msg-id 200507130231.j6D2V0726931@candle.pha.pa.us
Whole thread Raw
In response to Re: [PATCHES] thousands comma numeric formatting in psql  (David Fetter <david@fetter.org>)
List pgsql-hackers
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
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] HEAD doesn't cope with libraries in non-default
Next
From: Christopher Kings-Lynne
Date:
Subject: Order by optimisations?