Re: Fixes for missing schema qualifications
| От | David G. Johnston |
|---|---|
| Тема | Re: Fixes for missing schema qualifications |
| Дата | |
| Msg-id | CAKFQuwYGXhD7ngZ-xJHg+GR8Avn5nPhcv7g_yWxD8fLH+DqNhw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Fixes for missing schema qualifications (Tatsuo Ishii <ishii@sraoss.co.jp>) |
| Ответы |
Re: Fixes for missing schema qualifications
Re: Fixes for missing schema qualifications |
| Список | pgsql-hackers |
>>> + "select pg_catalog.count(*) "
>>> + "from pg_catalog.pg_namespace where nspname = '%s'",
>>
>> This qualifies some functions, but it leaves plenty of unqualified operators.
Oops. I meant:
select pg_catalog.count(*) from pg_catalog.pg_namespace where pg_catalog.nameeq(nspname, '%s');
I'd rather write that:
select [...] where nspname operator(pg_catalog.=) '%s'
Introducing undocumented implementation functions to these queries is undesirable; and besides, indexing and equivalence relies on operators and not the underlying functions so there would be some risk of performance issues if the functions were used directly.
David J.
В списке pgsql-hackers по дате отправления: