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 по дате отправления: