ember 13, 2006 5:01 PM
To: Brandon Aiken
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] INSERT INTO row value constructors
On Wed, Dec 13, 2006 at 04:55:00PM -0500, Brandon Aiken wrote:
> This is just an odd question. Previously RDBMSs (MySQL, SQLite, IIRC)
I've used have allo
On Wed, Dec 13, 2006 at 04:55:00PM -0500, Brandon Aiken wrote:
> This is just an odd question. Previously RDBMSs (MySQL, SQLite, IIRC) I've
> used have allowed row value constructors (optional feature F641 in SQL'03) on
> INSERT statements. That is:
>
> INSERT INTO mytable
> VALUES (0,'hello')
This is just an odd question. Previously RDBMSs (MySQL, SQLite, IIRC) I've
used have allowed row value constructors (optional feature F641 in SQL'03) on
INSERT statements. That is:
INSERT INTO mytable
VALUES (0,'hello'),(1,'world');
Is essentially shorthand for:
INSERT INTO mytable VALUES (0
