X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 7A1A09FB42D for ; Thu, 31 Aug 2006 15:43:20 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 58129-04-2 for ; Thu, 31 Aug 2006 15:43:12 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.184]) by postgresql.org (Postfix) with ESMTP id 246D39FB434 for ; Thu, 31 Aug 2006 15:43:05 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id n28so512123nfc for ; Thu, 31 Aug 2006 11:43:04 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=DKUKUKCsS0fAKWMxn9Wv4L4t6RK1m0YVZQWzb6EIFLn+YTr+1YAhOzqMuulZ0CJYBoGWHHsrAFM19C6wfZoqKAjzLVKuzmiVBUxVcZKbUn7jyFtp+F3e3k1s9Llkrfne50XDJgWZ9BA0EBkA/We/ai8wSUqGoNOikQmuyXBaeWM= Received: by 10.67.101.8 with SMTP id d8mr716864ugm; Thu, 31 Aug 2006 11:43:04 -0700 (PDT) Received: by 10.67.118.11 with HTTP; Thu, 31 Aug 2006 11:43:03 -0700 (PDT) Message-ID: <55c095e90608311143q677946by7aa55da061dbbd5a@mail.gmail.com> Date: Thu, 31 Aug 2006 15:43:03 -0300 From: "Ezequias Rodrigues da Rocha" To: pgsql-sql@postgresql.org Subject: How to get the row that start a trigger MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_67614_24622729.1157049783808" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.819 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_40_50, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/252 X-Sequence-Number: 26210 ------=_Part_67614_24622729.1157049783808 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi, I need make a trigger that update a table each time another table has a insert. but this insert has on this row all the items to pass to my functio= n on the trigger. How to retrieve this information. Please I need this answare. Regards Ezequias --=20 =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- A pior das democracias ainda =E9 melhor do que a melhor das ditaduras The worst of democracies is still better than the better of dictatorships http://ezequiasrocha.blogspot.com/ ------=_Part_67614_24622729.1157049783808 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi,

I need make a trigger that update a table each time another tabl= e has a insert. but this insert has on this row all the items to pass to my= function on the trigger.

How to retrieve this information.

Please I need this answare.

Regards
Ezequias
--
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-= =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-
           =             &nb= sp;          Atenciosamen= te (Sincerely)
            &nb= sp;           Ezequi= as Rodrigues da Rocha
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-= =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-
A pior das democracias ainda =E9 melhor do que a m= elhor das ditaduras
The worst of democracies is still better than the be= tter of dictatorships
http://ezequiasrocha.bl= ogspot.com/ ------=_Part_67614_24622729.1157049783808--