Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 36EFD633BAF for ; Mon, 20 Jul 2009 10:19:55 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 31253-05 for ; Mon, 20 Jul 2009 10:19:36 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from web54304.mail.re2.yahoo.com (web54304.mail.re2.yahoo.com [206.190.49.114]) by mail.postgresql.org (Postfix) with SMTP id 4EBBF633BBC for ; Mon, 20 Jul 2009 10:19:44 -0300 (ADT) Received: (qmail 7442 invoked by uid 60001); 20 Jul 2009 13:19:41 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1248095981; bh=Vl4ma9/vNDyr/lVxPF7xuv6lA44T9o/qnDgxCcyqlTI=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=2EJSqWGIzNXBwMZwCBJfpCYBQXA4ZhSiluCKGL+pxD+mNupr1up/kRqJEd+Dd2D3hKo53b/01Nqagg8g93043tvfkHNP7vuO9ZoS21CVS2653Om3De5l0WUm4eHRZ5jrzpy3qRFOlrLZ+PtBh+m8cj1OlpVHPh04rEJcjzMRL+M= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=yDQhRjivatCBpGUW1ey/OqEo2XsevSF2DhjrubwkJZCzOD2OICvYoI/hgjxCkJKVBlkLIBEl47cWq/rlGY2vnu8s+R/t7lq2FYwYfVNJbFOwnmbQpqyQrbTCcPKGYQZiTd1t8nc0B7coFhRTsg/zG2nCuXJav/pohd9/5YCOIRw=; Message-ID: <74512.7116.qm@web54304.mail.re2.yahoo.com> X-YMail-OSG: NLN5iyIVM1njK964Sm_al_Z6F3WF7hQVhG1zrYZNmnIr6Si_qP6cc6VmiIYJtlbDQTFDkHK99KD19552h9KR1wrg.DXsaT1cnzYypD2sfmuPghssisc5XlOUytfgSeMljpaEA2vI4F_keEocaCndOmCu3a8utMMWhexsS2OvvLWkSv7toVy.P0iS3sT6cHf24KoAtkvBTyqrtEXwu8WCAKCuwmpmNOdoGbwAiLvhO3XQAalLaxKI87iK.fqM51v8m0_hlMlcI6ma_jasks8ZPn1Ptv9kks8gqFxWN43lNUWUghd7nApEjovq7TehGjbuhw-- Received: from [68.25.42.245] by web54304.mail.re2.yahoo.com via HTTP; Mon, 20 Jul 2009 06:19:39 PDT X-Mailer: YahooMailClassic/5.4.17 YahooMailWebService/0.7.289.15 Date: Mon, 20 Jul 2009 06:19:39 -0700 (PDT) From: chester c young Subject: how to tell if column set on update To: sql pgsql MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200907/83 X-Sequence-Number: 32824 within a trigger need to know if the UPDATE statement set a column. the column might be set to the old value or a different value. (want to make sure the app is sending all necessary values) thanks