| From: | "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com> |
|---|---|
| To: | "Andreas Pflug" <pgadmin(at)pse-consulting(dot)de> |
| Cc: | <pgsql-hackers(at)postgresql(dot)org>, "Marek Mosiewicz" <marekmosiewicz(at)poczta(dot)onet(dot)pl> |
| Subject: | Re: Compiere ERP and SQL quirks |
| Date: | 2005-01-07 19:10:46 |
| Message-ID: | 6EE64EF3AB31D5448D0007DD34EEB3412A759E@Herge.rcsinc.local |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Andreas wrote:
> Marek Mosiewicz wrote:
> > Upps sorry now found it on TODO list.
> >
> > I was not aware that it is SQL92 standard.
> >
> > Is it difficult to implement ?
> > Simplest approach would be
> > to rewrite it to UPDATE t1 set col1 = (select cola ...), col2 =
(select
> > colb....) ....
> > but it would result in not optimal plan.
>
> Doesn't something like
>
> UPDATE t1 SET col1=cola, col2=colb
> FROM t1 JOIN anothertable ot ON t1.id=ot.id
> WHERE ...
>
> Work the way you'd like it? I'd expect this syntax to be as widely
> portable and performant.
Hmm, 'from' in an update is a PostgreSQL extension to the update command
:).
Merlin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2005-01-07 19:35:20 | Re: Compiere ERP and SQL quirks |
| Previous Message | David Fetter | 2005-01-07 18:45:22 | Re: PostgreSQL 8.0.0 Release Candidate 4 |