From: Ashish Karalkar <ashish.karalkar@info-spectrum.com>
To: hu js <hu.bill2005@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: How to use serial variable to insert into muiti-recrods?
Date: Thu, 6 Sep 2007 13:18:23 +0530
Message-ID: <018f01c7f05a$653bf6e0$170211ac@LIONKING.COM> (raw)
References: <BAY102-F21BF5CEECBDF3E1F70C90CF0C40@phx.gbl>
I think default is a key word whic u r using as a column name in select
statment.
With Regards
Ashish...
----- Original Message -----
From: "hu js" <hu.bill2005@hotmail.com>
To: <pgsql-sql@postgresql.org>
Sent: Thursday, September 06, 2007 12:41 PM
Subject: [SQL] How to use serial variable to insert into muiti-recrods?
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ashish.karalkar@info-spectrum.com, hu.bill2005@hotmail.com
Subject: Re: How to use serial variable to insert into muiti-recrods?
In-Reply-To: <018f01c7f05a$653bf6e0$170211ac@LIONKING.COM>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox