Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0JK8OV71352 for ; Sat, 19 Jan 2002 15:08:24 -0500 (EST) (envelope-from sszabo@megazone23.bigpanda.com) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id BCE6DD5F1; Sat, 19 Jan 2002 12:08:24 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id B29965BF4; Sat, 19 Jan 2002 12:08:24 -0800 (PST) Date: Sat, 19 Jan 2002 12:08:24 -0800 (PST) From: Stephan Szabo To: chester c young Cc: Subject: Re: table alias on update and delete query In-Reply-To: <20020119185355.58065.qmail@web12705.mail.yahoo.com> Message-ID: <20020119120642.X76854-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200201/240 X-Sequence-Number: 6324 On Sat, 19 Jan 2002, chester c young wrote: > is there no table alias on update and dml query? is there workaround? AFAIK, only use the full table name and alias any other copies. > egg=# update lw_pres p1 set pid=pid+1 > egg(# where exists( select 1 from lw_pres p2 > egg(# where p1.pid = p2.pid and p1.oid < p2.oid ); > > ERROR: parser: parse error at or near "p1"