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]

Reply via email to