Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id A5FCE2E0039 for ; Sat, 2 Feb 2008 21:27:29 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 35433-01 for ; Sat, 2 Feb 2008 21:27:18 -0400 (AST) Received: from hs-out-2122.google.com (hs-out-0708.google.com [64.233.178.246]) by postgresql.org (Postfix) with ESMTP id ADEA92E0081 for ; Sat, 2 Feb 2008 21:27:25 -0400 (AST) Received: by hs-out-2122.google.com with SMTP id k27so1664068hsc.3 for ; Sat, 02 Feb 2008 17:27:24 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=+Kx85qTZJZmMJsS3a2Uv02FpB65XO4LmM95ei5H2PMw=; b=eWiidm637X77PYePvHj5oczSZsvGlJDDArsUxHihOqhcpoK2jxb1PM5z5N2tI2cNRMJGnZ7Agyv/rdJusi5sdwC0HHeyJdZ2Xmu91CL1gGYca9rs05euw51cnfSYkg3f5jjTbNRYhOogt55nC5jFABFjafLuehN3wACuoM5aGBI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=QGB0I7q3ayXaoim731/fZoURjD6EzaGFhYhTdbGwe0HooYtVoCFNjmFfBuzXTwMmgJyJY8lMMvpFj7XQWRFLCUy6kLGSX6I45U4GGZ+BB1LHVYisyIVWz5J8W5W6PmyCVkZpNkoMZjqVV56woREgwdqMVkXuDjSAuojaOIrgP1I= Received: by 10.142.231.7 with SMTP id d7mr2892772wfh.194.1202002043561; Sat, 02 Feb 2008 17:27:23 -0800 (PST) Received: by 10.143.53.4 with HTTP; Sat, 2 Feb 2008 17:27:23 -0800 (PST) Message-ID: <36e682920802021727q2a62e29dh9280c546d1973347@mail.gmail.com> Date: Sat, 2 Feb 2008 20:27:23 -0500 From: "Jonah H. Harris" To: "Adrian Klaver" Subject: Re: can a insert with a returning clause be subquery ? Cc: pgsql-sql@postgresql.org, chrisj In-Reply-To: <200802021640.56174.aklaver@comcast.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <15248628.post@talk.nabble.com> <36e682920802021612w5b04ca7dk80925b913f4b7261@mail.gmail.com> <200802021640.56174.aklaver@comcast.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/7 X-Sequence-Number: 30098 On Feb 2, 2008 7:40 PM, Adrian Klaver wrote: > Would this be a variation of this item from the TODO: > > * Allow INSERT/UPDATE ... RETURNING inside a SELECT 'FROM' clause Exactly. -- Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 499 Thornall Street, 2nd Floor | jonah.harris@enterprisedb.com Edison, NJ 08837 | http://www.enterprisedb.com/