X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2C81F3A5EA4 for ; Thu, 27 Jan 2005 13:04:15 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 54210-08 for ; Thu, 27 Jan 2005 13:04:10 +0000 (GMT) Received: from hm03.locaweb.com.br (hm03.locaweb.com.br [200.234.203.3]) by svr1.postgresql.org (Postfix) with SMTP id B2B353A5EA2 for ; Thu, 27 Jan 2005 13:04:11 +0000 (GMT) Received: (qmail 29281 invoked by uid 0); 27 Jan 2005 13:04:09 -0000 Received: from unknown (200.246.179.93) by hm03.locaweb.com.br with QMTP; 27 Jan 2005 13:04:09 -0000 Received: (qmail 4281 invoked from network); 27 Jan 2005 13:04:10 -0000 Received: from unknown (HELO ?192.168.1.86?) (wilton.wonrath@microwork.inf.br@200.246.46.224) by hm28.locaweb.com.br with SMTP; 27 Jan 2005 13:04:11 -0000 Received: from 127.0.0.1 (AVG SMTP 7.0.300 [265.7.6]); Thu, 27 Jan 2005 11:02:35 -0300 Message-ID: <41F8F477.7090100@microwork.inf.br> Date: Thu, 27 Jan 2005 11:02:31 -0300 From: Wilton User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: pt-br, pt To: pgsql-sql@postgresql.org Subject: Re: Complete instruction in a trigger Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="=======AVGMAIL-41F8F47B3906=======" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.051 tagged_above=0 required=5 tests=AWL, HTML_30_40, HTML_MESSAGE, HTML_TITLE_EMPTY X-Spam-Level: X-Archive-Number: 200501/285 X-Sequence-Number: 20073 --=======AVGMAIL-41F8F47B3906======= Content-Type: multipart/alternative; boundary=------------090203030307080409080001 --------------090203030307080409080001 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit Sorry if iīm sendind this question to the wrong place... itīs because iīm new here and i didnīt found the place in the web to send my question over the same that i already did. But letīs see if you can help me. The situation is like this. I have a table "customers", then a user go there and change the customer record, for example he changes the zip code column. Then I can know that something changed into the "customer table", and send a full update of that record through the web to the database that i want, but i need to know what column had changed to send a update just for that column. But i do not know in which column his has made that change. So, i need to know the instruction to do this. Something like a specific update for that column modified by the user. Thanks very much. Wilton Ruffato Wonrath --------------090203030307080409080001 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Sorry if i´m sendind this question to the wrong place... it´s because i´m new here and i didn´t found the place in the web to send my question over the same that i already did.

But let´s see if you can help me. The situation is like this.

I have a table "customers", then a user go there and change the customer record, for example he changes the zip code column. Then I can know that something changed into the "customer table", and send a full update of that record through the web to the database that i want, but i need to know what column had changed to send a update just for that column. But i do not know in which column his has made that change. So, i need to know the instruction to do this. Something like a specific update for that column modified by the user.

Thanks very much.

Wilton Ruffato Wonrath
--------------090203030307080409080001-- --=======AVGMAIL-41F8F47B3906======= Content-Type: text/plain; x-avg=cert; charset=us-ascii Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Content-Description: "AVG certification" No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.7.6 - Release Date: 27/1/2005 --=======AVGMAIL-41F8F47B3906=======--