Doug Quale <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html