From: Josh Berkus <josh@agliodbs.com>
To: Joseph Syjuco <joseph@asti.dost.gov.ph>
To: pgsql-sql@postgresql.org
Subject: Re: INSERT Syntax
Date: Mon, 03 Sep 2001 12:33:42 -0700
Message-ID: <web-112904@davinci.ethosmedia.com> (raw)
In-Reply-To: <FHEOJMCOMLCBGLEMAKOGMENPCCAA.joseph@asti.dost.gov.ph>
Joseph,
> insert into table1(field1,field2) values (select field1, field2 from
> table
> 2);
Actually, that won't work in SQL Server either. The correct syntax (for
both databases) is:
INSERT INTO table1 ( field1, field2 )
SELECT field1, field2 FROM table2;
The "VALUES" syntax is only appropriate if you are inserting a set of
constants with no SELECT statement involved.
-Josh Berkus
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
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: josh@agliodbs.com, joseph@asti.dost.gov.ph
Subject: Re: INSERT Syntax
In-Reply-To: <web-112904@davinci.ethosmedia.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