Quirks in Sorting Pg_description - Mailing list pgsql-admin

From P
Subject Quirks in Sorting Pg_description
Date
Msg-id BLU0-SMTP6181655A9EC3DB104B4AFFB43A0@phx.gbl
Whole thread Raw
Responses Re: Quirks in Sorting Pg_description
List 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 by date:

Previous
From: Major Services
Date:
Subject: Re: Restart failed with 'service postgresql restart'
Next
From: Major Services
Date:
Subject: Re: password authentication failed for user postgres