Re: column "id" is of type integer but expression is of type character - Mailing list pgsql-general

On Thursday 08 January 2009, "Andrus" <kobruleht2@hot.ee> wrote:
> Commands:
>
> create temp table test ( id int, baas char(10) );
> create temp table lisa ( id int, baas char(10) );
> alter table lisa drop column id;
> INSERT INTO test SELECT * FROM lisa;


> How to fix ?

INSERT INTO test (baas)  SELECT baas FROM lisa;


--
Current Peeve: The mindset that the Internet is some sort of school for
novice sysadmins and that everyone -not- doing stupid dangerous things
should act like patient teachers with the ones who are. -- Bill Cole, NANAE