inserting multiple values in version 8.1.5

From: "rkmr(dot)em(at)gmail(dot)com" <rkmr(dot)em(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: inserting multiple values in version 8.1.5
Date: 2007-04-03 03:20:32
Message-ID: e04d2e90704022020u465cfc6dldf371689f0ba11b5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Gerhardt 2007-04-03 03:24:46 UPDATE on two large datasets is very slow
Previous Message Steve Atkins 2007-04-03 01:03:59 Re: documentation generator for pgsql