Message-ID: <3bf871577cdcdb0c8006337214dfc2886ebfb81f.camel@cybertec.at>
Subject: Re: Is it possible to have comma as default decimal seperator
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: "Subramanian,Ramachandran" <ramachandran.subramanian@alte-leipziger.de>,
  "pgsql-novice@lists.postgresql.org"	 <pgsql-novice@lists.postgresql.org>
Date: Thu, 26 Feb 2026 11:58:38 +0100
In-Reply-To: <4a26d8587ec84b3b989f6867abfe8e48@alte-leipziger.de>
References: <4a26d8587ec84b3b989f6867abfe8e48@alte-leipziger.de>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.58.3 (3.58.3-1.fc43) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/3bf871577cdcdb0c8006337214dfc2886ebfb81f.camel%40cybertec.at>
Precedence: bulk

On Thu, 2026-02-26 at 10:12 +0000, Subramanian,Ramachandran wrote:
> =C2=A0=C2=A0 is it possible to globally set the COMMA as the decimal sepa=
rator for an instance instead of the DOT.=C2=A0
> =C2=A0
> =C2=A0=C2=A0=C2=A01. Is it possible
> =C2=A0=C2=A0=C2=A02. If yes, how would one convert all the DBs in an exis=
ting instance.

I assume you would like to use the comma as decimal separator in your
SQL statements, like

  UPDATE konto SET betrag =3D 23,50 WHERE kontonummer =3D 42;

That is not possible.

However, if you set the parameter "lc_numeric" to a German locale, you
can use the comma with the function to_number():

  SET lc_numeric =3D "de_DE.utf8";

  SELECT to_number('23,50', '999999999D99');

   to_number=20
  =E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=
=E2=95=90=E2=95=90=E2=95=90
       23.50
  (1 row)

Yours,
Laurenz Albe