Re: [SQL] Junk queries with variables?

2005-02-25 Thread KÖPFERL Robert
PL/pgSQL is not part of template1 = if you create a new database. Thus you can use for functions just pure SQL or C. To get pgSQL I did that: CREATE OR REPLACE FUNCTION plpgsql_call_handler() RETURNS language_handler AS '$libdir/plpgsql', 'plpgsql_call_handler' LANGUAGE 'c' VOLATILE; CREATE

Re: [SQL] [GENERAL] Are SQL queries locale dependent?

2005-02-25 Thread Tom Lane
=?iso-8859-1?Q?Martin_Sch=E4fer?= <[EMAIL PROTECTED]> 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 obvi

[SQL] Are SQL queries locale dependent?

2005-02-25 Thread Martin Schäfer
Hi, 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 que