Doug Quale <quale1(at)charter(dot)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