Hello,
I believe types are compatible if they can be cast automatically.
The pg_cast table record all possible casts between types. If it castcontext
is 'a' then I belive it's an automatic conversion which is what I think you
want. 'i' implicit means that cast is possible, but must be explicit
On Sat, Mar 6, 2010 at 4:34 PM, Gianvito Pio wrote:
> Hi all,
> is there a way to check if two attribute are type compatible (for example
> integer and serial, integer and integer, character varying and text, etc..)?
>
> Example:
> IF (compatible (table1.att1, table2.att2)) THEN
>...
> EL
