Joe Conway <[EMAIL PROTECTED]> writes: > That's even better -- I tried regproc, but forgot about > regprocedure. I think the problem will be, though, that the output of > the reg* datatypes is not castable to text, and therefore cannot be > used to build a dynamic sql statement.
This must be why test=# select oid::regprocedure from pg_proc order by oid::regprocedure; doesn't sort the way I would expect. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org