Re: Are SQL queries locale dependent?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Are SQL queries locale dependent?
Дата
Msg-id 5469.1109346713@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Are SQL queries locale dependent?  (Martin Schäfer <Martin.Schaefer@cadcorp.com>)
Список pgsql-general
=?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

В списке pgsql-general по дате отправления:

Предыдущее
От: Dave Smith
Дата:
Сообщение: JDBC and Portals . Clarification
Следующее
От: Tom Lane
Дата:
Сообщение: Re: postgresql 8.0 advantages