pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: INSERT Syntax
1+ messages / 1 participants
[nested] [flat]
* Re: INSERT Syntax
@ 2001-09-03 19:33 Josh Berkus <josh@agliodbs.com>
0 siblings, 0 replies; 1+ messages in thread
From: Josh Berkus @ 2001-09-03 19:33 UTC (permalink / raw)
To: Joseph Syjuco <joseph@asti.dost.gov.ph>; pgsql-sql
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
^ permalink raw reply [nested|flat] 1+ messages in thread
only message in thread
Thread overview: 1+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-09-03 19:33 Re: INSERT Syntax Josh Berkus <josh@agliodbs.com>
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