Re: INSERT INTO problem

On Tue, 20 Feb 2001, Tom Jenkins wrote:

> Hello all,
> I'm trying to do an INSERT INTO using a UNION of two selects.  I
> received an error:
>   "ERROR:  Unable to convert varchar to int2 for column isdepartment"
>
> I started simplifying the INSERT INTO to help me get to the root cause.
> I removed the UNION and continued simplifying.
>
> I eventually ended up with this line that still gives me the error:
> insert into reportentity
>    select 'D0'||text(departmentid) as reportentityid,
>    departmentname as reportentityname,
>    '1'::int2 as isdepartment,
>    departmentdescription as reportentitydescription,
>    departmentsummary as reportentitysummary
> from department where isreportentity > 0;

I do not believe that it uses the aliases you give to say which columns
those are associated with.  I think you need to have the select items
in the same order as the columns, so, it's erroring trying to convert
a departmentsummary value to an int2.  Reordering the columns should
help.