Re: How to convert integer to boolean in insert

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: JiangMiao <jiangfriend(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: How to convert integer to boolean in insert
Date: 2009-04-05 16:00:47
Message-ID: 4894.1238947247@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Martijn van Oosterhout <kleptog(at)svana(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jennifer Trey 2009-04-05 18:28:09 Connect to server PG from laptop java app
Previous Message Martijn van Oosterhout 2009-04-05 12:36:12 Re: How to convert integer to boolean in insert