Re: UPDATE with JOIN - Mailing list pgsql-novice

"Keith Worthington" <keithw@narrowpathinc.com> writes:
> UPDATE tbl_line_item
>    SET tbl_line_item.reviewed = TRUE
>   FROM tbl_item
>     ON ( tbl_line_item.item_id = tbl_item.id )
>  WHERE item_type = 'DIR';

Of course that's not valid JOIN syntax (no JOIN keyword, and no place to
put it either).  You have to use the WHERE clause:

UPDATE tbl_line_item
   SET tbl_line_item.reviewed = TRUE
  FROM tbl_item
 WHERE tbl_line_item.item_id = tbl_item.id
       AND item_type = 'DIR';

            regards, tom lane