Bob(dot)Henkel(at)hartfordlife(dot)com writes:
> When I try an update like the one below I get the error that follows.
> update report_base s
> set s.sql_base = 'select * from test_data where'
> where s.report_base_id = 1;
> ERROR: syntax error at or near "s" at character 20
This is correct per SQL standard. There are some other databases that
allow an alias for the UPDATE target, but not Postgres.
regards, tom lane