Postgres Pro
Downloads
Home   >   mailing lists

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

From rkmr.em@gmail.com
Subject inserting multiple values in version 8.1.5
Date
Msg-id e04d2e90704022020u465cfc6dldf371689f0ba11b5@mail.gmail.com
Whole thread Raw
Responses Re: inserting multiple values in version 8.1.5  (Chris <dmagick@gmail.com>)
Re: inserting multiple values in version 8.1.5  ("Greg Sabino Mullane" <greg@turnstep.com>)
List pgsql-general
Tree view
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

What to do?
thanks


pgsql-general by date:

Previous
From: Steve Atkins
Date:
Subject: Re: documentation generator for pgsql
Next
From: Chris
Date:
Subject: Re: inserting multiple values in version 8.1.5