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

From: "hu js" <hu(dot)bill2005(at)hotmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: How to use serial variable to insert into muiti-recrods?
Date: 2007-09-06 07:11:18
Message-ID: BAY102-F21BF5CEECBDF3E1F70C90CF0C40@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

run:
"CREATE TABLE xxx
(
id serial NOT NULL,
name character varying
);
insert into xxx select default values,place_name from air_bui;"

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

How can I do?

Bill Gates

_________________________________________________________________
与联机的朋友进行交流，请使用 MSN Messenger: http://messenger.msn.com/cn

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ashish Karalkar 2007-09-06 07:48:23 Re: How to use serial variable to insert into muiti-recrods?
Previous Message Sabin Coanda 2007-09-05 14:54:24 Re: ISO time zone format