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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073