Tom Lane <tgl@sss.pgh.pa.us> writes:
> 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.
Thanks for the explanation. Some months ago I had tried
oid::regprocedure::text and found it didn't work. I didn't figure out
that this was because I need to create a cast procedure.