Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-sql-owner+M36981=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1Tfcnd-0003NY-SZ
	for pgsql-sql@arkaria.postgresql.org; Mon, 03 Dec 2012 20:39:33 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgsql-sql-owner+M36981=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1Tfcnc-0005me-Rz
	for pgsql-sql@arkaria.postgresql.org; Mon, 03 Dec 2012 20:39:32 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <sql-pgsql-sql@m.gmane.org>) id 1Tf9E7-0001LU-80
	for pgsql-sql@postgresql.org; Sun, 02 Dec 2012 13:04:55 +0000
Received: from plane.gmane.org ([80.91.229.3])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <sql-pgsql-sql@m.gmane.org>) id 1Tf9E6-000709-Bo
	for pgsql-sql@postgresql.org; Sun, 02 Dec 2012 13:04:54 +0000
Received: from list by plane.gmane.org with local (Exim 4.69)
	(envelope-from <sql-pgsql-sql@m.gmane.org>) id 1Tf9EG-0000Yo-O7
	for pgsql-sql@postgresql.org; Sun, 02 Dec 2012 14:05:04 +0100
Received: from ip-118-90-121-46.xdsl.xnet.co.nz ([118.90.121.46])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <pgsql-sql@postgresql.org>; Sun, 02 Dec 2012 14:05:04 +0100
Received: from jasen by ip-118-90-121-46.xdsl.xnet.co.nz with local (Gmexim
	0.1 (Debian)) id 1AlnuQ-0007hv-00
	for <pgsql-sql@postgresql.org>; Sun, 02 Dec 2012 14:05:04 +0100
X-Injected-Via-Gmane: http://gmane.org/
To: pgsql-sql@postgresql.org
From: Jasen Betts <jasen@xnet.co.nz>
Subject: Re: Can't get upsert working.
Date: 2 Dec 2012 09:56:19 GMT
Organization: Dis (not Dat) Organisation
Lines: 11
Message-ID: <k9f8k3$u4$2@reversiblemaps.ath.cx>
References: 
 <CAFCtE1=xUHzWQcpBQ7tSxFfQwJO-Pay2jFyfWHZ5dPDuAPhnEg@mail.gmail.com>
	<k9f3hc$u4$1@reversiblemaps.ath.cx>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
X-Complaints-To: usenet@ger.gmane.org
X-Gmane-NNTP-Posting-Host: ip-118-90-121-46.xdsl.xnet.co.nz
X-Face: ?)Aw4rXwN5u0~$nqKj`xPz>xHCwgi^q+^?Ri*+R(&uv2=E1Q0Zk(>h!~o2ID@6{uf8s; a
	+M[5[U[QT7xFN%^gR"=tuJw%TXXR'Fp~W;
	(T"1(739R%m0Yyyv*gkGoPA.$b,D.w:z+<'"=-lVT?6
	{T?=R^:W5g|E2#EhjKCa+nt":4b}dU7GYB*HBxn&Td$@f%.kl^:7X8rQWd[NTc"P"u6nkisze/Q;
	8 "9Z{peQF,w)7UjV$c|RO/mQW/NMgWfr5*$-Z%u46"/00mx-,\R'fLPe.)^
User-Agent: slrn/pre1.0.0-18 (Linux)
X-Pg-Spam-Score: -0.3 (/)
List-Archive: <http://archives.postgresql.org/pgsql-sql>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-sql.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@postgresql.org>
List-Post: <mailto:pgsql-sql@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-sql>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
X-Mailing-List: pgsql-sql
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

On 2012-12-02, Jasen Betts <jasen@xnet.co.nz> wrote:
> On 2012-11-30, Bert <biertie@gmail.com> wrote:
>
>> Anyone here with upsert experience?

This guy "Depesz" does:

http://www.depesz.com/2012/06/10/why-is-upsert-so-complicated/

-- 
⚂⚃ 100% natural



-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql