From: | Alvaro Herrera <alvherre(at)surnet(dot)cl> |
---|---|
To: | Juanky Moral <juanky(dot)moral(at)gmail(dot)com> |
Cc: | Victor <victor(dot)perez(at)e-evolution(dot)com>, pgsql-es-ayuda(at)postgresql(dot)org |
Subject: | Re: Port Oracle to PostgreSQL Compiere |
Date: | 2005-07-04 19:15:29 |
Message-ID: | 20050704191529.GA23100@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
On Mon, Jul 04, 2005 at 08:42:44PM +0200, Juanky Moral wrote:
> EN POSTGRES:
> UPDATE AD_User SET
> AD_User.C_Greeting_ID=I_BPartner.C_Greeting_ID,
> AD_User.Name=I_BPartner.Name,
> ....el resto de la comalist set...
> FROM AD_User INNER JOIN I_BPartner ON
> AD_User.C_Greeting_ID=I_BPartner.I_BPartner_ID;
No tienes que repetir la tabla AD_User en el FROM. Ya esta
implicitamente incluida, por ser la tabla a la que haces UPDATE. Me
parece que haciendo esto tienes un producto cartesiano.
> O de forma más genérica:
> UPDATE [ ONLY ] table SET column = { expression | DEFAULT } [, ...]
> [ FROM fromlist ]
> [ WHERE condition ]
Agregar a esto la lectura la documentacion de UPDATE.
--
Alvaro Herrera (<alvherre[a]surnet.cl>)
"Everybody understands Mickey Mouse. Few understand Hermann Hesse.
Hardly anybody understands Einstein. And nobody understands Emperor Norton."
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2005-07-04 19:18:47 | Re: duda sobre programacion en postgre |
Previous Message | Alvaro Herrera | 2005-07-04 19:10:30 | Re: Port Oracle to PostgreSQL Compiere |