On Fri, 25 Jul 2003, Maksim Likharev wrote:
> My be I too spoiled by MS SQL Server, but does'nt
> syntax:
>
> update prod.t_results set expdate=e.termdate from
> work.termdate e, prod.t_results r where e.docid=r.docid;
> or
> update prod.t_results set expdate=e.termdate from
> work.termdate e inner join prod.t_results r on e.docid=r.docid;
>
> is standard SQL-92 update FROM form?
No. There is no standard SQL-92 update FROM syntax (nor SQL 99 AFAICS).
I'd guess that it'd be standardized to do what we do for a query like
the above because in one case the reference name for the table is
t_results and in the other it's r.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
