Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 4B5709F9E45 for ; Thu, 6 Sep 2007 04:11:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 46213-06 for ; Thu, 6 Sep 2007 04:11:16 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from bay0-omc2-s10.bay0.hotmail.com (bay0-omc2-s10.bay0.hotmail.com [65.54.246.146]) by postgresql.org (Postfix) with ESMTP id D632A9F9BB3 for ; Thu, 6 Sep 2007 04:11:23 -0300 (ADT) Received: from hotmail.com ([64.4.61.31]) by bay0-omc2-s10.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.3959); Thu, 6 Sep 2007 00:11:22 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 6 Sep 2007 00:11:22 -0700 Message-ID: Received: from 64.4.61.244 by by102fd.bay102.hotmail.msn.com with HTTP; Thu, 06 Sep 2007 07:11:18 GMT X-Originating-IP: [203.125.54.38] X-Originating-Email: [hu.bill2005@hotmail.com] X-Sender: hu.bill2005@hotmail.com From: "hu js" To: pgsql-sql@postgresql.org Subject: How to use serial variable to insert into muiti-recrods? Date: Thu, 06 Sep 2007 07:11:18 +0000 Mime-Version: 1.0 Content-Type: text/plain; charset=gb2312; format=flowed X-OriginalArrivalTime: 06 Sep 2007 07:11:22.0575 (UTC) FILETIME=[215985F0:01C7F055] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.352 tagged_above=0 required=5 tests=AWL=0.351, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200709/54 X-Sequence-Number: 29267 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