Re: How to convert integer to boolean in insert

Martijn van Oosterhout <kleptog@svana.org> writes:
> On Sun, Apr 05, 2009 at 04:14:37AM -0700, JiangMiao wrote:
>> Is there any way to make pgsql implicit cast the integer to boolean?

> You might want to create the cast temporarily and after the import
> remove it again.

The cast exists already, so he can't just "create" it.  Personally, what
I'd do is modify the pg_cast entry for it (set castcontext to 'a' and
then revert when done).

            regards, tom lane