Re: [PATCHES] thousands comma numeric formatting in psql

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.

> > 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?

Cheers,
D
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778

Remember to vote!