Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 9AE08133616B
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 17 Dec 2010 15:02:10 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 58404-06 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 17 Dec 2010 19:02:03 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from andromeda.neonex.com.br (dns1.neonex.com.br [186.225.19.19])
	by mail.postgresql.org (Postfix) with ESMTP id C845A133655C
	for <pgsql-sql@postgresql.org>; Fri, 17 Dec 2010 15:02:02 -0400 (AST)
Received: from [201.20.39.226] (helo=[127.0.0.1])
	by andromeda.neonex.com.br with esmtpa (Exim 4.72)
	(envelope-from <luiz@planit.com.br>)
	id 1PTfYy-0003Ki-V5; Fri, 17 Dec 2010 17:01:57 -0200
Message-ID: <4D0BB39A.9040204@planit.com.br>
Date: Fri, 17 Dec 2010 17:01:46 -0200
From: "Luiz K. Matsumura" <luiz@planit.com.br>
Organization: Plan IT Tecnologia =?ISO-8859-1?Q?Inform=E1tica_Ltda=2E?=
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; pt-BR;
	rv:1.9.2.13) Gecko/20101207 Thunderbird/3.1.7
MIME-Version: 1.0
To: pgsql-sql@postgresql.org, jasen@xnet.co.nz
Subject: Re: UPDATE in a specific order
References: <4D0A28F0.3020205@planit.com.br>
	<iedr1q$dv1$1@reversiblemaps.ath.cx>
In-Reply-To: <iedr1q$dv1$1@reversiblemaps.ath.cx>
Content-Type: multipart/alternative;
	boundary="------------050702020909050108090001"
X-Antivirus: avast! (VPS 101217-0, 17/12/2010), Outbound message
X-Antivirus-Status: Clean
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.899 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201012/87
X-Sequence-Number: 34923

This is a multi-part message in MIME format.
--------------050702020909050108090001
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Thanks  for reply,

Em 16/12/2010 17:58, Jasen Betts escreveu:
>> I need to make update of table1 with data on table2 in the order of id
>> of table2
> that looks like EAV. is it?
>

Err, I donīt know so much about EAV, so I think that isnīt. Iīm just 
trying to reproduce a calc in a spreeadsheet.
>> There are some way to do this with a UPDATE statement ?
> to do it with an update statement you need no more than one rows in the
> from for each row in the target.
>
> easiest non update statement approach is probably to use a plpgsql
> function with a loop.
>
> basically you need to find another way to do it.
>

Ok! I make a function in plpgsql to do it.

Thankīs again !

*
*

--------------050702020909050108090001
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#ffffff" text="#000000">
    Thanks&nbsp; for reply,<br>
    <br>
    Em 16/12/2010 17:58, Jasen Betts escreveu:
    <blockquote cite="mid:iedr1q$dv1$1@reversiblemaps.ath.cx"
      type="cite">
      <blockquote type="cite">
        <pre wrap="">I need to make update of table1 with data on table2 in the order of id
of table2
</pre>
      </blockquote>
      <pre wrap="">
that looks like EAV. is it?

</pre>
    </blockquote>
    <br>
    Err, I don&acute;t know so much about EAV, so I think that isn&acute;t. I&acute;m just
    trying to reproduce a calc in a spreeadsheet.
    <blockquote cite="mid:iedr1q$dv1$1@reversiblemaps.ath.cx"
      type="cite">
      <blockquote type="cite">
        <pre wrap="">There are some way to do this with a UPDATE statement ?
</pre>
      </blockquote>
      <pre wrap="">
to do it with an update statement you need no more than one rows in the
from for each row in the target.

easiest non update statement approach is probably to use a plpgsql 
function with a loop.

basically you need to find another way to do it.

</pre>
    </blockquote>
    <br>
    Ok! I make a function in plpgsql to do it.<br>
    <br>
    Thank&acute;s again !<br>
    <div class="moz-signature"><br>
      <b><br>
      </b></div>
  </body>
</html>

--------------050702020909050108090001--