Re: How to access the extension's operator installed with schema ?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How to access the extension's operator installed with schema ?
Дата
Msg-id 19830.1347651379@sss.pgh.pa.us
обсуждение исходный текст
Ответ на How to access the extension's operator installed with schema ?  (xoip <sorin.mircioiu@gmail.com>)
Ответы Re: How to access the extension's operator installed with schema ?  (xoip <sorin.mircioiu@gmail.com>)
Список pgsql-general
xoip <sorin.mircioiu@gmail.com> writes:
> CREATE SCHEMA inty AUTHORIZATION psql_user;
> CREATE EXTENSION intarray SCHEMA inty;
> SELECT inty.uniq(ARRAY[1,2,3]); --> OK, result: {1,2,3}

> How can I access the operator with inty schema?

The easy way is to change your search_path to include inty.
If you really don't want to do that, you can write
    OPERATOR(inty.+)
but that's pretty inconvenient.

            regards, tom lane


В списке pgsql-general по дате отправления:

Предыдущее
От: "K, Baraneetharan"
Дата:
Сообщение: PostgreSql support for Windows 8
Следующее
От: Paul Jungwirth
Дата:
Сообщение: Re: See the WHERE clause of a partial index