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

Поиск
Список
Период
Сортировка
От hu js
Тема How to use serial variable to insert into muiti-recrods?
Дата
Msg-id BAY102-F21BF5CEECBDF3E1F70C90CF0C40@phx.gbl
обсуждение исходный текст
Ответы Re: How to use serial variable to insert into muiti-recrods?  ("Milen A. Radev" <milen@radev.net>)
Re: How to use serial variable to insert into muiti-recrods?  (Richard Huxton <dev@archonet.com>)
Re: How to use serial variable to insert into muiti-recrods?  (Jean-David Beyer <jeandavid8@verizon.net>)
Список 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  



В списке pgsql-sql по дате отправления:

Предыдущее
От: "Sabin Coanda"
Дата:
Сообщение: Re: ISO time zone format
Следующее
От: "Ashish Karalkar"
Дата:
Сообщение: Re: How to use serial variable to insert into muiti-recrods?