Tom Lane <[EMAIL PROTECTED]> writes: > 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.
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. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]