=?iso-8859-1?Q?Martin_Sch=E4fer?= <Martin.Schaefer@cadcorp.com> writes:
> I recently found out that my app doesn't work in Spain because it creates localized queries like this:
> create table t (c1 float8, c2 float8);
> insert into t (c1, c2) values (3,14159, 1,4142);
> I understand that PostgreSQL obviously can't parse this query. But I'm not sure how to fix this query so that it
worksunder all circumstances.
Use dots. The SQL syntax for a number is not locale-dependent.
regards, tom lane