On 11/04/2013 05:21 PM, Josh Berkus wrote:
> Thom,
>
>
>> SELECT
>> castsource::regtype::text,
>> array_agg(casttarget::regtype order by casttarget::regtype::text) casttargets
>> FROM pg_cast
>> WHERE castmethod = 'b'
>> GROUP BY 1
>> ORDER BY 1;
>
> Are we actually covering 100% of these for ALTER COLUMN now?
Also, JSON <--> Text seems to be missing from the possible binary
conversions. That's a TODO, I suppose.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com