Received: from web12705.mail.yahoo.com (web12705.mail.yahoo.com [216.136.173.242]) by postgresql.org (8.11.3/8.11.4) with SMTP id g0JIrxV53625 for ; Sat, 19 Jan 2002 13:53:59 -0500 (EST) (envelope-from chestercyoung@yahoo.com) Message-ID: <20020119185355.58065.qmail@web12705.mail.yahoo.com> Received: from [207.188.162.30] by web12705.mail.yahoo.com via HTTP; Sat, 19 Jan 2002 10:53:55 PST Date: Sat, 19 Jan 2002 10:53:55 -0800 (PST) From: chester c young Subject: table alias on update and delete query To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200201/239 X-Sequence-Number: 6323 is there no table alias on update and dml query? is there workaround? 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" __________________________________________________ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/