Re: Identifying casts

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marc Munro <marc(at)bloodnok(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Identifying casts
Date: 2007-12-08 00:57:28
Message-ID: 415.1197075448@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Marc Munro <marc(at)bloodnok(dot)com> writes:
> Is there any way of identifying whether a cast was built-in or is
> user-defined?

It's not easy. I'd suggest following the same heuristic pg_dump
does, which is that if any of the source type, target type, or
underlying function is considered user-defined, then the cast is too.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-12-08 01:11:42 Re: Array index not used for query on first element?
Previous Message Amit Phatarphekar 2007-12-07 23:57:40 Returning columns from different tables, in plpgsql function