=?iso-8859-1?Q?Martin_Sch=E4fer?= <Martin.Schaefer@xxxxxxxxxxx> 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 works under all circumstances.
Use dots. The SQL syntax for a number is not locale-dependent.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
