Re: inserting multiple values in version 8.1.5 - Mailing list pgsql-general

From Chris
Subject Re: inserting multiple values in version 8.1.5
Date
Msg-id 4611CA38.8080107@gmail.com
Whole thread Raw
In response to inserting multiple values in version 8.1.5  ("rkmr.em@gmail.com" <rkmr.em@gmail.com>)
Responses Re: inserting multiple values in version 8.1.5  ("rkmr.em@gmail.com" <rkmr.em@gmail.com>)
List pgsql-general
rkmr.em@gmail.com wrote:
> Hi
> I am trying to insert multiple values into a table like this.
> INSERT INTO tab_name (col1, col2) VALUES (val1, val2), (val3, val4)
>
> This works in postgres version 8.2.1
>
> My production server runs in 8.1.5. It gives me
> ERROR:  syntax error at or near "," at character 35

That came in at v8.2.

You can't use it in 8.1.5.

--
Postgresql & php tutorials
http://www.designmagick.com/

pgsql-general by date:

Previous
From: "rkmr.em@gmail.com"
Date:
Subject: inserting multiple values in version 8.1.5
Next
From: "Ashish Karalkar"
Date:
Subject: Re: Problem restoring from backup file