Re: Selecting user-defined CASTs

On 09.08.2011 08:27, Tom Lane wrote:
> select ... from pg_cast c where c.oid>= 16384;
>
> What that really does is eliminate the casts that were installed during
> initdb, which are at least a subset of the "system" ones, and might be
> all of them depending on what you feel a "system" cast is.  The main
> shortcoming of it is that there's no very good way to eliminate casts
> installed by extensions, should you want to not consider those "user"
> casts.

That will also exclude "system" casts that have been removed, and 
manually re-created later.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com