Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2FFxWx22465 for ; Thu, 15 Mar 2001 10:59:32 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f2FFx2t13910; Thu, 15 Mar 2001 10:59:06 -0500 (EST) To: Jeff Putsch cc: pgsql-sql@postgresql.org Subject: Re: Help with UPDATE syntax In-reply-to: <20010314224729.A16150@blue.mxim.com> References: <20010314224729.A16150@blue.mxim.com> Comments: In-reply-to Jeff Putsch message dated "Wed, 14 Mar 2001 22:47:29 -0800" Date: Thu, 15 Mar 2001 10:59:02 -0500 Message-ID: <13907.984671942@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200103/308 X-Sequence-Number: 1972 Jeff Putsch writes: > update > user_group_map map Postgres doesn't allow UPDATE to use an alias for the target table (SQL92 doesn't either). Get rid of the alias name "map", and write the full table name "user_group_map" in the places where "map" is used in the WHERE clause. regards, tom lane