Re: Help with UPDATE syntax

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Putsch <putsch(at)mxim(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Help with UPDATE syntax
Date: 2001-03-15 15:59:02
Message-ID: 13907.984671942@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Jeff Putsch <putsch(at)mxim(dot)com> 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Davis 2001-03-15 15:59:27 RE: Help with UPDATE syntax
Previous Message Jan Wieck 2001-03-15 15:02:51 Re: PL/PgSQL and NULL