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
On Fri, 7 Jan 2005, Merlin Moncure wrote:
> Marek Mosiewicz wrote:
> > Hello
> >
> > We made Compiere (Open source ERP system) to Firebird (Fyracle)
> > This is special version of Firebird with added Oracle compatibility
> > (Oracle
> > PL/SQL).
> > It made porting much easier, but our experience
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)
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
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Merlin Moncure
Sent: Friday, January 07, 2005 6:15 PM
To: Marek Mosiewicz
Cc: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Compiere ERP and SQL quirks
Marek Mosiewicz wrote:
> Hello
>
> We made Compi
Marek Mosiewicz wrote:
> Hello
>
> We made Compiere (Open source ERP system) to Firebird (Fyracle)
> This is special version of Firebird with added Oracle compatibility
> (Oracle
> PL/SQL).
> It made porting much easier, but our experience show that it
> would be now also not very difficult with o
Hello
We made Compiere (Open source ERP system) to Firebird (Fyracle)
This is special version of Firebird with added Oracle compatibility (Oracle
PL/SQL).
It made porting much easier, but our experience show that it
would be now also not very difficult with other databases like PostgreSQL.
Compie
