Re: inserting multiple values in version 8.1.5

From: Chris <dmagick(at)gmail(dot)com>
To: "rkmr(dot)em(at)gmail(dot)com" <rkmr(dot)em(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: inserting multiple values in version 8.1.5
Date: 2007-04-03 03:30:00
Message-ID: 4611CA38.8080107@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

rkmr(dot)em(at)gmail(dot)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/

In response to

Responses

Browse pgsql-general by date

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