Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id A1AC22E00C4
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 20 Mar 2008 09:14:27 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 81819-10 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 20 Mar 2008 09:14:17 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from el-out-1112.google.com (el-out-1112.google.com
 [209.85.162.178])
	by postgresql.org (Postfix) with ESMTP id D73002E00CD
	for <pgsql-sql@postgresql.org>; Thu, 20 Mar 2008 09:14:24 -0300 (ADT)
Received: by el-out-1112.google.com with SMTP id z25so700816ele.0
	for <pgsql-sql@postgresql.org>; Thu, 20 Mar 2008 05:14:23 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	bh=4tEQzjgD6l+O235vw4HjrCPubXqbERtfN2hdZ+2MXo8=;
	b=DCZp4KUvmkyUaQ6JVTAGrhf8fq6SxX+JfN5dhMKR8lZ0UqVznwfUU9vaI4+Jxtpb4PdHUblFlup+6OkD10EGkP1VqDmJLRf1u5krdoaz+JfFAAlnOv5eNoIhdOkEaNnfHSOydMZmTV/JxaLvBh9MYq0zN8P2Y0DOgJ3GgTQSbDE=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=eIeqCRc/moTW/8iq+b6Mz89/CF/sXlwB+S6BD2GAIdXDlULKmpv080QzjiwD8WBdZbpt/1bGcwvsdr5VBgJLd8Ig9q+RBUJPPD/CI1lUFedzRaVfoDFHDDaNnCg/yIfqHNgjjw4G/Zjgj339CI6QfkVJUkUBPzc6SvKb8WKV5s8=
Received: by 10.115.79.1 with SMTP id g1mr3454988wal.2.1206015263355;
	Thu, 20 Mar 2008 05:14:23 -0700 (PDT)
Received: by 10.114.27.16 with HTTP; Thu, 20 Mar 2008 05:14:23 -0700 (PDT)
Message-ID: <65937bea0803200514o5bc8e244x27b94db1f0feb31f@mail.gmail.com>
Date: Thu, 20 Mar 2008 17:44:23 +0530
From: "Gurjeet Singh" <singh.gurjeet@gmail.com>
To: "Craig Ringer" <craig@postnewspapers.com.au>
Subject: Re: Select into
Cc: "Gavin 'Beau' Baumanis" <gavinb@eclinic.com.au>, pgsql-sql@postgresql.org,
	"A. Kretschmer" <andreas.kretschmer@schollglas.com>
In-Reply-To: <47E252F8.6030008@postnewspapers.com.au>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_14319_19170318.1206015263382"
References: <94F93C0F-DA95-4435-B253-57C90961DF34@eclinic.com.au>
	<20080320104922.GB18935@a-kretschmer.de>
	<65937bea0803200358i290bdc87hdeca777b593b5df1@mail.gmail.com>
	<786D2B38-CE0A-41BF-9E70-4DEB22F8D9EF@eclinic.com.au>
	<47E252F8.6030008@postnewspapers.com.au>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200803/139
X-Sequence-Number: 30467

------=_Part_14319_19170318.1206015263382
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On Thu, Mar 20, 2008 at 5:35 PM, Craig Ringer <craig@postnewspapers.com.au>
wrote:

>
> craig=3D# explain update x set val =3D foundrow.val from ( select val fro=
m x
> where id =3D 4123 ) as foundrow where id =3D 5912 ;
>

Thats nifty.



--=20
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB http://www.enterprisedb.com

17=B0 29' 34.37"N, 78=B0 30' 59.76"E - Hyderabad *
18=B0 32' 57.25"N, 73=B0 56' 25.42"E - Pune
37=B0 47' 19.72"N, 122=B0 24' 1.69" W - San Francisco

http://gurjeet.frihost.net

Mail sent from my BlackLaptop device

------=_Part_14319_19170318.1206015263382
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On Thu, Mar 20, 2008 at 5:35 PM, Craig Ringer &lt;<a href=3D"mailto:craig@p=
ostnewspapers.com.au">craig@postnewspapers.com.au</a>&gt; wrote:<br><div cl=
ass=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"border-left:=
 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex=
;">
<br>
craig=3D# explain update x set val =3D foundrow.val from ( select val from =
x<br>
where id =3D 4123 ) as foundrow where id =3D 5912 ;<br></blockquote><div><b=
r>Thats nifty.<br>&nbsp;</div></div><br clear=3D"all"><br>-- <br>gurjeet[.s=
ingh]@EnterpriseDB.com<br>singh.gurjeet@{ gmail | hotmail | indiatimes | ya=
hoo }.com<br>
<br>EnterpriseDB <a href=3D"http://www.enterprisedb.com">http://www.enterpr=
isedb.com</a><br><br>17=B0 29&#39; 34.37&quot;N, 78=B0 30&#39; 59.76&quot;E=
 - Hyderabad *<br>18=B0 32&#39; 57.25&quot;N, 73=B0 56&#39; 25.42&quot;E - =
Pune<br>
37=B0 47&#39; 19.72&quot;N, 122=B0 24&#39; 1.69&quot; W - San Francisco<br>=
<br><a href=3D"http://gurjeet.frihost.net">http://gurjeet.frihost.net</a><b=
r><br>Mail sent from my BlackLaptop device

------=_Part_14319_19170318.1206015263382--