returning on inserts

From: chester c young <chestercyoung(at)yahoo(dot)com>
To: sql pgsql <pgsql-sql(at)postgresql(dot)org>
Subject: returning on inserts
Date: 2008-03-27 19:24:05
Message-ID: 13907.84888.qm@web54307.mail.re2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Allan Kamau 2008-03-31 08:16:17 Removing redundant itemsets
Previous Message Craig Ringer 2008-03-27 18:02:31 Re: link to Jsp