Re: Compiere ERP and SQL quirks

#1 (**permalink**) 04-11-2008, 03:13 AM

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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

#2 (**permalink**) 04-11-2008, 03:13 AM

Merlin Moncure wrote:
> Andreas wrote:
>

>>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
>

.

Ooops... Oracle doesn't know it, I used to use it on MSSQL.

Regards,
Andreas

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode