Re: Fixes for missing schema qualifications
От | Tatsuo Ishii |
---|---|
Тема | Re: Fixes for missing schema qualifications |
Дата | |
Msg-id | 20180314.092615.1619108768998317925.t-ishii@sraoss.co.jp обсуждение исходный текст |
Ответ на | Re: Fixes for missing schema qualifications ("David G. Johnston" <david.g.johnston@gmail.com>) |
Ответы |
Re: Fixes for missing schema qualifications
Re: Fixes for missing schema qualifications |
Список | pgsql-hackers |
>> 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. Thanks. Yours looks much better. Next question is, should we update the manual? There are bunch of places where example queries are shown without schema qualifications. Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:http://www.sraoss.co.jp
В списке pgsql-hackers по дате отправления: