Search Postgresql Archives
inserting multiple values in version 8.1.5
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- To: pgsql-general@xxxxxxxxxxxxxx
- Subject: inserting multiple values in version 8.1.5
- From: "rkmr.em@xxxxxxxxx" <rkmr.em@xxxxxxxxx>
- Date: Mon, 2 Apr 2007 20:20:32 -0700
- Dkim-signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=j7tV+HBHz9HuQvc7Gs7CG86tiMSvo853/CL6qRhB7dyKud8Fm37H8nVCX+SO5Vt3sRoGrwd1I0HnZagAEESf+ApbSEPQYsxsZZupR9Nb9KYpWq8ObNDSmJm6A6YFCRMbc01nQPeXMjNGD2pMt14QmIM/zQhfFhBVdzRjQV0uvqE=
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
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]