"Keith Worthington" <keithw(at)narrowpathinc(dot)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