Re: casting from integer to boolean - Mailing list pgsql-general

From Adam Rich
Subject Re: casting from integer to boolean
Date
Msg-id 04dd01c88f91$a032c1d0$e0984570$@r@sbcglobal.net
Whole thread Raw
In response to Re: casting from integer to boolean  (Seb <spluque@gmail.com>)
Responses Re: casting from integer to boolean
List pgsql-general
> Thanks Richard.  Is there a way to do it without changing the INSERT
> command?  As I mentioned, there are many more columns of different
> types, so finding and replacing the VALUES would be very difficult.

Can you import the data into a holding table (with columns defined
as integer) first, and then use a SQL statement to insert from there
into the final destination table (casting in the process) ?



pgsql-general by date:

Previous
From: Seb
Date:
Subject: Re: casting from integer to boolean
Next
From: Sam Mason
Date:
Subject: Re: casting from integer to boolean