| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | Maksim Likharev <mlikharev(at)aurigin(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Wacky query plan, why? |
| Date: | 2003-07-26 00:58:50 |
| Message-ID: | 20030725175449.H48568-100000@megazone.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2003-07-26 01:16:00 | Re: Using YY-MM-DD date input |
| Previous Message | Mike Mascari | 2003-07-26 00:25:13 | Re: Wacky query plan, why? |