X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6FB6ED8D17 for ; Thu, 15 Sep 2005 06:25:27 -0300 (ADT) 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 66373-05 for ; Thu, 15 Sep 2005 09:25:21 +0000 (GMT) Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.203]) by svr1.postgresql.org (Postfix) with ESMTP id 94066D8C16 for ; Thu, 15 Sep 2005 06:25:17 -0300 (ADT) Received: by xproxy.gmail.com with SMTP id i27so326350wxd for ; Thu, 15 Sep 2005 02:25:20 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=qBBoQYC1Xqt6OHfsoqzuIin7j0/yXCL5BJJGe+1QtsCKLzKxS/vdp2xLgA58vLPmZPk29i7gnJDBvk7w0l1h+uRg87+wWzQNjtWkGllJgDVSxFAPagpjdBVijlV8Y1pRs+4zcbJNUJjfF0c5DUX5mMRoMs0VRKneptA+W+94UxU= Received: by 10.70.40.14 with SMTP id n14mr279441wxn; Thu, 15 Sep 2005 02:25:20 -0700 (PDT) Received: by 10.70.25.13 with HTTP; Thu, 15 Sep 2005 02:25:19 -0700 (PDT) Message-ID: Date: Thu, 15 Sep 2005 10:25:19 +0100 From: Neil Saunders Reply-To: n.j.saunders@gmail.com To: pgsql-sql@postgresql.org Subject: Triggers & Conditional Assignment Mime-Version: 1.0 Content-Type: text/plain; charset=WINDOWS-1252 Content-Transfer-Encoding: base64 Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.856 required=5 tests=[RCVD_BY_IP=0.024, RCVD_IN_BL_SPAMCOP_NET=1.832] X-Spam-Level: * X-Archive-Number: 200509/156 X-Sequence-Number: 22703 SGksCgpJJ3ZlIHJ1biBpbiB0byBhIHNtYWxsIHByb2JsZW0gd2hlbiB3cml0aW5nIGEgdHJpZ2dl ci4KCkZvciBzaW1wbGljaXRpZXMgc2FrZSBsZXRzIHNheSB0aGF0IEkgaGF2ZSAyIHRhYmxlcyCW ICdib29raW5ncycgYW5kCid1bmF2YWlsYWJsZV9wZXJpb2RzJy4gQm90aCBoYXZlIGNvbHVtbnMg J3N0YXJ0X2RhdGUnLCdlbmRfZGF0ZScsIGFuZAoncHJvcGVydHlfaWQnLgoKSSBoYXZlIHdyaXR0 ZW4gYSB0cmlnZ2VyIHRoYXQgaXMgZmlyZWQgb24gaW5zZXJ0cyBhbmQgdXBkYXRlcyBmb3IgYm90 aAp0YWJsZXMgdGhhdCBzaW1wbHkgZW5zdXJlcyB0aGF0IG5vIGludGVydmFscyAoZGVmaW5lZCBi eSBzdGFydF9kYXRlCmFuZCBlbmRfZGF0ZSkgb3ZlcmxhcCBmb3IgdGhlIHNhbWUgcHJvcGVydHkg YWNyb3NzIGJvdGggdGFibGVzLgoKSXQgd29ya3Mgc2ltcGx5IGJ5IGRvaW5nIGEgU0VMRUNUIHVz aW5nIHRoZSBPVkVSTEFQIGtleXdvcmQgb24KTkVXLnN0YXJ0X2RhdGUsIGFuZCBORVcuZW5kX2Rh dGUgZm9yIGJvdGggdGFibGVzIChJZ25vcmluZyB0aGUgcmVjb3JkCmJlaW5nIG1vZGlmaWVkKS4g VGhpcyB3b3JrcyBmaW5lIG9uIGluc2VydHMgKFdoZXJlIGJvdGggc3RhcnRfZGF0ZSBhbmQKZW5k X2RhdGUgYXJlIHNwZWNpZmllZCksIGFuZCB1cGRhdGVzIHRoYXQgbW9kaWZ5IGJvdGggc3RhcnRf ZGF0ZSBhbmQKZW5kX2RhdGUsIGJ1dCBmb3IgdXBkYXRlcyB3aGVyZSBJIG9ubHkgdXBkYXRlICdz dGFydF9kYXRlJywgZm9yCmV4YW1wbGUsIHRoZSB0cmlnZ2VyIGZhaWxzIGJlY2F1c2UgTkVXLmVu ZF9kYXRlIGlzIGVtcHR5LgoKV2hhdHMgdGhlIGJlc3Qgd2F5IGFyb3VuZCB0aGlzPwoKSSd2ZSB0 cmllZCB0byB3cml0ZSBzb21ldGhpbmcgYWxvbmcgdGhlIGxpbmVzIG9mIHRoZSBmb2xsb3dpbmc6 CgpERUNMQVJFCiAgICBzZGF0ZSBEQVRFOwogICAgZWRhdGUgREFURTsKCkJFR0lOCiAgICBzZGF0 ZSA9IChORVcuc3RhcnRfZGF0ZSBJUyBOT1QgTlVMTCkgPyBORVcuc3RhcnRfZGF0ZSA6IE9MRC5z dGFydF9kYXRlOwogICAgZWRhdGUgPSAoTkVXLmVuZF9kYXRlIElTIE5PVCBOVUxMKSA/IE5FVy5l bmRfZGF0ZSA6IE9MRC5lbmRfZGF0ZTsKhQoKQnV0IGNvbmRpdGlvbmFsIGFzc2lnbm1lbnQgZG9l c24ndCBzZWVtIHRvIGJlIGNhdGVyZWQgZm9yLiBUaGUgbmV4dApiZXN0IHRoaW5nIGlzIGEgc2Vy aWVzIG9mIElGIFRIRU4gRUxTSUYgRUxTRSBzdGF0ZW1lbnRzIHRvIGFzc2lnbgpzZGF0ZSBhbmQg ZWRhdGUsIG9yIGlzIHRoZXJlIGFub3RoZXIgdGVjaG5pcXVlIHRoYXQgSSd2ZSBtaXNzZWQKZW50 aXJlbHk/CgpLaW5kIFJlZ2FyZHMsCgpOZWlsIFNhdW5kZXJzLgo=