-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: 06 September 2017 15:49
To: Rob Northcott
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Dealing with number formats when server and client are
different locales
Rob Northcott writes:
> The problem we
Rob Northcott writes:
> The problem we've got is that our app (running on PCs) generates commands to
> send to the SQL server, such as
> UPDATE customers SET cus_balance = 10.4 WHERE cus_key = 'A001'
> This has been working historically because the clients were always UK-based.
> Now some users
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: 06 September 2017 13:36
To: Rob Northcott
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Dealing with number formats when server and client are
different locales
Rob Northcott writes:
> Our application
Rob Northcott writes:
> Our application was written assuming that the SQL server local settings for
> number formats would be the same as the client machine running the
> application.
> Now there is a need for some clients to run using UK format (full stop for
> decimal separator) and some to b
