Re: How to use serial variable to insert into muiti-recrods?

hu js написа:
> run:
> "CREATE TABLE xxx
> (
> id serial NOT NULL,
> name character varying
> );
> insert into xxx select default values,place_name from air_bui;"

insert into xxx (name) select place_name from air_bui;

> 
> fail:
> "ERROR: syntax error at or near "default"
> SQL state: 42601
> Character: 24"
> 


-- 
Milen A. Radev