compatibility issue with DirectFunctionCall1
От | Pavel Stehule |
---|---|
Тема | compatibility issue with DirectFunctionCall1 |
Дата | |
Msg-id | BANLkTikyY7UW7rNcZ3fYq+eaonAMO01isA@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: compatibility issue with DirectFunctionCall1
|
Список | pgsql-hackers |
Hello, I am working on testing Orafce for PostgreSQL 9.1. I found a issue. I cannot directly call a function "lower". Is it correct? select dbms_assert.enquote_name('''"AAA'); ! enquote_name. ! -------------- ! "'""aaa" ! (1 row) !. select dbms_assert.enquote_name('''"AAA', false); enquote_name. -------------- --- 1180,1188 ---- (1 row) .. select dbms_assert.enquote_name('''"AAA'); ! ERROR: could not determine which collation to use for lower() function ! HINT: Use the COLLATE clause to set the collation explicitly. ! CONTEXT: SQL function "enquote_name" statement 1 select dbms_assert.enquote_name('''"AAA', false); enquote_name. Datum dbms_assert_enquote_name(PG_FUNCTION_ARGS) { <------>Datum name = PG_GETARG_DATUM(0); <-->bool loweralize = PG_GETARG_BOOL(1); <------>name = DirectFunctionCall1(quote_ident, name); <------>if (loweralize) <------><------>name = DirectFunctionCall1(lower, name); <------>PG_RETURN_DATUM(name); } Regards Pavel Stehule
В списке pgsql-hackers по дате отправления: