Re: grant execute on many functions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: grant execute on many functions
Дата
Msg-id 8987.1088608020@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: grant execute on many functions  (Doug Quale <quale1@charter.net>)
Ответы Re: grant execute on many functions
Re: grant execute on many functions
Список pgsql-admin
Doug Quale <quale1@charter.net> writes:
> test=# select oid::regprocedure from pg_proc order by oid::regprocedure;

> doesn't sort the way I would expect.

Nope, it'd just be ordering by the numeric OID.  If you added a cast
procedure as we were just discussing, you could order by
oid::regprocedure::text and get what I suppose you're expecting.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PITR Error Message assistance
Следующее
От: Tom Lane
Дата:
Сообщение: Re: PL/pgSQL