Re: Are SQL queries locale dependent?

=?iso-8859-1?Q?Martin_Sch=E4fer?=  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