From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | Tom Jenkins <tjenkins(at)devis(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: INSERT INTO problem |
Date: | 2001-02-20 20:40:53 |
Message-ID: | Pine.BSF.4.21.0102201238110.3478-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Jenkins | 2001-02-20 20:46:28 | Re: INSERT INTO problem |
Previous Message | Len Morgan | 2001-02-20 20:19:05 | Re: Printing PostgreSQL reports |