Skip site navigation (1) Skip section navigation (2)

Re: PGSQL - FAQ 4.1

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Carsten Grewe <DerReisende(at)schatzis(dot)org>
Cc: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: PGSQL - FAQ 4.1
Date: 2002-01-03 06:37:19
Message-ID: 200201030637.g036bJb18143@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
OK, can someone comment on this email I received.  I am confused myself.
FAQ item 4.1 says:

> 4.1) Why is system confused about commas, decimal points, and date formats.

Does locale only control dates?  If so, why the mention of commas?  This
item was there before I started maintaining the FAQ.
 

---------------------------------------------------------------------------

Carsten Grewe wrote:
> Hi Bruce!
> 
> Below you'll find a question I asked to the pgsql-general list. I 
> missunderstood FAQ 4.1. Maybe it's just me - maybe the answer to the FAQ is 
> irritating - it's for you to judge.
> 
> Kind regards and merry Christmas
> Carsten
> 
> ----------  forwarded message  ----------
> 
> Subject: Re: [GENERAL] localization
> Date: Fri, 21 Dec 2001 13:06:20 +0100
> From: Carsten Grewe <DerReisende(at)schatzis(dot)org>
> To: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
> 
> Karel Zak, Freitag, 21. Dezember 2001 10:09:
> > On Thu, Dec 20, 2001 at 10:24:31PM +0100, Carsten Grewe wrote:
> > > I am a bit lost here. I have tried to convince pgsql to show numbers with
> > > a decimal-comma (german style) instead of the decimal-point.
> [snip]
> >
> >  The backend ignore LC_NUMERIC. If you want output numbers in locale
> >  depend format use to_char() (for example to_char(1234.5, '9G999D9').
> >
> >         Karel
> 
> Thanks! I know about the Format Functions, but FAQ 4.1 made me believe that
> there is a way to influence the backend.
> 
> VVVVVVVVV
> 4.1) Why is system confused about commas, decimal points, and date formats.
> 
> Check your locale configuration. PostgreSQL uses the locale setting of the
> user that ran the postmaster process. There are postgres and psql SET
> commands to control the date format. Set those accordingly for your operating
> environment.
> VVVVVVVVV
> 
> Kind regards and merry Christmas
> Carsten
> 
> -------------------------------------------------------
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2002-01-03 07:20:16
Subject: Re: LWLock contention: I think I understand the problem
Previous:From: Bruce MomjianDate: 2002-01-03 06:25:52
Subject: Re: contrib idea

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group