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

[email protected] 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: "[email protected]"
Date:
Subject: inserting multiple values in version 8.1.5
Next
From: "Ashish Karalkar"
Date:
Subject: Re: Problem restoring from backup file