Hello you can use oid. When oid is greather than some constant, then cast is custom. The constant is different on any postgresq versions. You can get it on clean postgres with statement select max(oid) from pg_cast; Regards Pavel Stehule On 07/12/2007, Marc Munro <marc@xxxxxxxxxxxx> wrote: > Is there any way of identifying whether a cast was built-in or is > user-defined? > > I am tempted to just assume that if the cast is to/from a user-defined > type or uses a user-defined function that it is user-defined. I suspect > though that a user could define a new cast on pre-defined types using a > pre-defined function. > > __ > Marc > > ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings