Re: Wacky query plan, why? - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Wacky query plan, why?
Date
Msg-id 20030725175449.H48568-100000@megazone.bigpanda.com
Whole thread Raw
In response to Re: Wacky query plan, why?  ("Maksim Likharev" <mlikharev@aurigin.com>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: Mike Mascari
Date:
Subject: Re: Wacky query plan, why?
Next
From: Ron Johnson
Date:
Subject: Re: Using YY-MM-DD date input