Kevin Grittner <kgri...@ymail.com> wrote: > Whether it is a bug in Windows or in PostgreSQL character- > handling under Windows I can say myself, since I haven't > had any reason to use Windows for years.
Er, that should have been I *can't* say. >> create or replace function α(β int, ξ int, μ float) returns float as $$ >> select (β + ξ) * μ $$ language sql; >> select α(1, 2, 0.1); >> -- it works >> select ascii(proname), * from pg_proc where length(proname) = 1; >> -- return code 60536 although select ascii('α') retruns 945 >> select * from pg_proc where proname = 'α'; >> -- returns nothing It occurs to me that the behavior you are seeing would be consistent with 945 being considered an uppercase letter, with 60536 being considered its lowercase form. Normal PostgreSQL case-folding of identifiers would then cause exactly the symptoms you are seeing. You could test this theory by quoting its use as an identifier: create or replace function "α"(β int, ξ int, μ float) returns float as $$ select (β + ξ) * μ $$ language sql; select "α"(1, 2, 0.1); select ascii(proname), * from pg_proc where length(proname) = 1; select * from pg_proc where proname = 'α'; If that behaves correctly, you need to sort out what about your environment is causing the odd case-folding. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs