Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 44A972E0060 for ; Thu, 27 Mar 2008 16:24:11 -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 06458-08 for ; Thu, 27 Mar 2008 16:24:07 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web54307.mail.re2.yahoo.com (web54307.mail.re2.yahoo.com [206.190.49.117]) by postgresql.org (Postfix) with SMTP id 593862E0056 for ; Thu, 27 Mar 2008 16:24:10 -0300 (ADT) Received: (qmail 89295 invoked by uid 60001); 27 Mar 2008 19:24:06 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=A3bR63a4EOjd1uyND1sK2lbgzRsO7UJgrprnDN6Yytcrylf6/VPvuhGBGKvQUUisKcL8SbIQ2QsNLUiShfcz0YSwvWkAn4Sjg8kVbTQ20U8JhCj0B7h0qGPYX1CVAf4mYaJ3s8hLHboNXvKt+ZUcTqlC6/lnth9a1lWlICgK0Yk=; X-YMail-OSG: quFDl8oVM1mlWsIi9po2CQe0CFf9ADIxRqcgOHwcF8f27u9AtYAwIHfRHJlH2_761BTpHpowh.iZ9BriNVGrOqrO8IjLrMVB5t0TQjxi6_qCbLDMxfWIng9ggulrGqgdpikNU8gg7NMqSw-- Received: from [69.224.218.97] by web54307.mail.re2.yahoo.com via HTTP; Thu, 27 Mar 2008 12:24:05 PDT Date: Thu, 27 Mar 2008 12:24:05 -0700 (PDT) From: chester c young Subject: returning on inserts To: sql pgsql MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <13907.84888.qm@web54307.mail.re2.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/202 X-Sequence-Number: 30530 insert into t1( c1 ) select c1 from t2 returning t1.c1, t2.c2; ERROR: missing FROM-clause entry for table "t2" is there any way to make this work? ____________________________________________________________________________________ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs