Re: [SQL] Help with UPDATE syntax

2001-03-15 Thread Tom Lane
Jeff Putsch <[EMAIL PROTECTED]> 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 th

[SQL] Help with UPDATE syntax

2001-03-15 Thread Jeff Putsch
Howdy, I am porting a bit of code from ORACLE to PostgreSQL 7.1 and am getting stuck on an update statment. I am NOT a SQL expert, merely a beginner swimming hard, so any help will be greatly appreciated. The specific query looks like this: begin transaction update user_group