Re: casting from integer to boolean

From: Seb <spluque(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: casting from integer to boolean
Date: 2008-03-26 22:54:25
Message-ID: 8763v9qeou.fsf@patagonia.sebmags.homelinux.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 26 Mar 2008 17:34:59 -0500,
"Adam Rich" <adam(dot)r(at)sbcglobal(dot)net> wrote:

[...]

> 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) ?

Yes, that would be possible, but then I would have to know which columns
need to be casted back into boolean. I might find a way to do that
though. Thanks.

--
Seb

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-03-26 22:55:53 Re: casting from integer to boolean
Previous Message Richard Broersma 2008-03-26 22:46:47 Re: casting from integer to boolean