Re: How to use serial variable to insert into muiti-recrods? - Mailing list pgsql-sql

From Ashish Karalkar
Subject Re: How to use serial variable to insert into muiti-recrods?
Date
Msg-id 018f01c7f05a$653bf6e0$170211ac@LIONKING.COM
Whole thread Raw
In response to How to use serial variable to insert into muiti-recrods?  ("hu js" <hu.bill2005@hotmail.com>)
List pgsql-sql
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 



pgsql-sql by date:

Previous
From: "hu js"
Date:
Subject: How to use serial variable to insert into muiti-recrods?
Next
From: "Milen A. Radev"
Date:
Subject: Re: How to use serial variable to insert into muiti-recrods?