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  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Fixes for missing schema qualifications  (Noah Misch <noah@leadboat.com>)
Список 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 по дате отправления:

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: [HACKERS] Removing [Merge]Append nodes which contain a single subpath
Следующее
От: Andres Freund
Дата:
Сообщение: ExplainProperty* and units