Re: INSERT INTO row value constructors

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Brandon Aiken <BAiken(at)winemantech(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: INSERT INTO row value constructors
Date: 2006-12-13 22:01:28
Message-ID: 20061213220128.GF15546@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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'),(1,'world');

<snip>

> Is that correct, or is this behavior expected to change?

It's in 8.2, see the documentation:

http://www.postgresql.org/docs/current/static/dml-insert.html

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben 2006-12-13 22:01:46 Re: a question for the way-back machine
Previous Message Brandon Aiken 2006-12-13 21:55:00 INSERT INTO row value constructors