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@svana.org]
Sent: Wednesday, December 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 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@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability
to litigate.