Hi,
I am using postgresql 6.5 snapshot.
I can not update.
Could anyone tell me what's wrong, please?
update ibs_br_all_total_units tr set first_name=
(select first_name from ibs_subscriber tn
where tr.pin = tn.pin
);
"/tmp/psql.60000.13342" 4 lines, 117 characters
ERROR: parser: syntax error at or near "tr"
Thanks.
Regards,
Chai