Quirks in Sorting Pg_description

Поиск
Список
Период
Сортировка
От P
Тема Quirks in Sorting Pg_description
Дата
Msg-id BLU0-SMTP6181655A9EC3DB104B4AFFB43A0@phx.gbl
обсуждение исходный текст
Ответы Re: Quirks in Sorting Pg_description  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
The following query works from Psql's prompt but not from Psql's "-c"
command or from PHP's PDO interface.

SELECT description FROM pg_catalog.pg_description WHERE description
SIMILAR TO '\d+' ORDER BY description::integer DESC LIMIT 1;

The result should be the description with the highest integer value.
Instead it appears to be sorting like text even though it has been cast
to an integer.

Anyone know of a workaround?

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

Предыдущее
От: Major Services
Дата:
Сообщение: Re: Restart failed with 'service postgresql restart'
Следующее
От: Major Services
Дата:
Сообщение: Re: password authentication failed for user postgres