Re: INSERT INTO row value constructors

Cool.

Now I just have to wait for Debian backports, or figure it out for
myself if I can find the time.

*sigh* 8.2 isn't even in Portage yet.

--
Brandon Aiken
CS/IT Systems Engineer

-----Original Message-----
From: Martijn van Oosterhout [mailto:kleptog(at)svana(dot)org]
Sent: Wednesday, December 13, 2006 5:01 PM
To: Brandon Aiken
Cc: pgsql-general(at)postgresql(dot)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 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.