Postgres Pro
Downloads
Home   >   mailing lists

Re: Help with UPDATE syntax - Mailing list pgsql-sql

From Tom Lane
Subject Re: Help with UPDATE syntax
Date
Msg-id 13907.984671942@sss.pgh.pa.us
Whole thread Raw
In response to Help with UPDATE syntax  (Jeff Putsch <putsch@mxim.com>)
List pgsql-sql
Tree view 
Jeff Putsch <putsch@mxim.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

pgsql-sql by date:

Previous
From: Sondaar Roelof
Date:
Subject: RE: Some questions about PLpgSql
Next
From: Michael Davis
Date:
Subject: RE: Help with UPDATE syntax