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 38E48D8EB4 for ; Thu, 15 Sep 2005 06:58:10 -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 74303-07 for ; Thu, 15 Sep 2005 09:58:03 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.206]) by svr1.postgresql.org (Postfix) with ESMTP id C81A6D8C23 for ; Thu, 15 Sep 2005 06:58:04 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id j2so83835nzf for ; Thu, 15 Sep 2005 02:58:04 -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:cc:in-reply-to:mime-version:content-type:references; b=YMRAMXa9Qpbj384be61Cnga34jKH5Tu7ytnooUAUmsOietwYUGuK3Sv/lv5bSb5m5UKFiNnK3iB18224CO3XqhiIfs5jWxa0+xVHCidkQVkdahiKEvSFxk8Lb/JMTAe+MYEkrydk6K0zsrC5RaxgewDTAkDfBkxH0mWHp+mBv+A= Received: by 10.36.247.7 with SMTP id u7mr3130238nzh; Thu, 15 Sep 2005 02:58:04 -0700 (PDT) Received: by 10.36.120.14 with HTTP; Thu, 15 Sep 2005 02:58:04 -0700 (PDT) Message-ID: Date: Thu, 15 Sep 2005 15:28:04 +0530 From: Gnanavel S Reply-To: s.gnanavel@gmail.com To: n.j.saunders@gmail.com Subject: Re: Triggers & Conditional Assignment Cc: pgsql-sql@postgresql.org In-Reply-To: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1317_19584722.1126778284447" References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.503 required=5 tests=[AWL=-0.026, HTML_20_30=0.504, HTML_MESSAGE=0.001, RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200509/157 X-Sequence-Number: 22704 ------=_Part_1317_19584722.1126778284447 Content-Type: text/plain; charset=WINDOWS-1252 Content-Transfer-Encoding: base64 Content-Disposition: inline Y29hbGVzY2UoTkVXLmVuZF9kYXRlICwgT0xELmVuZF9kYXRlKSB3aWxsIHNvbHZlIHRoZSBpc3N1 ZS4KCk9uIDkvMTUvMDUsIE5laWwgU2F1bmRlcnMgPG4uai5zYXVuZGVyc0BnbWFpbC5jb20+IHdy b3RlOgo+IAo+IEhpLAo+IAo+IEkndmUgcnVuIGluIHRvIGEgc21hbGwgcHJvYmxlbSB3aGVuIHdy aXRpbmcgYSB0cmlnZ2VyLgo+IAo+IEZvciBzaW1wbGljaXRpZXMgc2FrZSBsZXRzIHNheSB0aGF0 IEkgaGF2ZSAyIHRhYmxlcyCWICdib29raW5ncycgYW5kCj4gJ3VuYXZhaWxhYmxlX3BlcmlvZHMn LiBCb3RoIGhhdmUgY29sdW1ucyAnc3RhcnRfZGF0ZScsJ2VuZF9kYXRlJywgYW5kCj4gJ3Byb3Bl cnR5X2lkJy4KPiAKPiBJIGhhdmUgd3JpdHRlbiBhIHRyaWdnZXIgdGhhdCBpcyBmaXJlZCBvbiBp bnNlcnRzIGFuZCB1cGRhdGVzIGZvciBib3RoCj4gdGFibGVzIHRoYXQgc2ltcGx5IGVuc3VyZXMg dGhhdCBubyBpbnRlcnZhbHMgKGRlZmluZWQgYnkgc3RhcnRfZGF0ZQo+IGFuZCBlbmRfZGF0ZSkg b3ZlcmxhcCBmb3IgdGhlIHNhbWUgcHJvcGVydHkgYWNyb3NzIGJvdGggdGFibGVzLgo+IAo+IEl0 IHdvcmtzIHNpbXBseSBieSBkb2luZyBhIFNFTEVDVCB1c2luZyB0aGUgT1ZFUkxBUCBrZXl3b3Jk IG9uCj4gTkVXLnN0YXJ0X2RhdGUsIGFuZCBORVcuZW5kX2RhdGUgZm9yIGJvdGggdGFibGVzIChJ Z25vcmluZyB0aGUgcmVjb3JkCj4gYmVpbmcgbW9kaWZpZWQpLiBUaGlzIHdvcmtzIGZpbmUgb24g aW5zZXJ0cyAoV2hlcmUgYm90aCBzdGFydF9kYXRlIGFuZAo+IGVuZF9kYXRlIGFyZSBzcGVjaWZp ZWQpLCBhbmQgdXBkYXRlcyB0aGF0IG1vZGlmeSBib3RoIHN0YXJ0X2RhdGUgYW5kCj4gZW5kX2Rh dGUsIGJ1dCBmb3IgdXBkYXRlcyB3aGVyZSBJIG9ubHkgdXBkYXRlICdzdGFydF9kYXRlJywgZm9y Cj4gZXhhbXBsZSwgdGhlIHRyaWdnZXIgZmFpbHMgYmVjYXVzZSBORVcuZW5kX2RhdGUgaXMgZW1w dHkuCj4gCj4gV2hhdHMgdGhlIGJlc3Qgd2F5IGFyb3VuZCB0aGlzPwo+IAo+IEkndmUgdHJpZWQg dG8gd3JpdGUgc29tZXRoaW5nIGFsb25nIHRoZSBsaW5lcyBvZiB0aGUgZm9sbG93aW5nOgo+IAo+ IERFQ0xBUkUKPiBzZGF0ZSBEQVRFOwo+IGVkYXRlIERBVEU7Cj4gCj4gQkVHSU4KPiBzZGF0ZSA9 IChORVcuc3RhcnRfZGF0ZSBJUyBOT1QgTlVMTCkgPyBORVcuc3RhcnRfZGF0ZSA6IE9MRC5zdGFy dF9kYXRlOwo+IGVkYXRlID0gKE5FVy5lbmRfZGF0ZSBJUyBOT1QgTlVMTCkgPyBORVcuZW5kX2Rh dGUgOiBPTEQuZW5kX2RhdGU7Cj4ghQo+IAo+IEJ1dCBjb25kaXRpb25hbCBhc3NpZ25tZW50IGRv ZXNuJ3Qgc2VlbSB0byBiZSBjYXRlcmVkIGZvci4gVGhlIG5leHQKPiBiZXN0IHRoaW5nIGlzIGEg c2VyaWVzIG9mIElGIFRIRU4gRUxTSUYgRUxTRSBzdGF0ZW1lbnRzIHRvIGFzc2lnbgo+IHNkYXRl IGFuZCBlZGF0ZSwgb3IgaXMgdGhlcmUgYW5vdGhlciB0ZWNobmlxdWUgdGhhdCBJJ3ZlIG1pc3Nl ZAo+IGVudGlyZWx5Pwo+IAo+IEtpbmQgUmVnYXJkcywKPiAKPiBOZWlsIFNhdW5kZXJzLgo+IAo+ IC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLShlbmQgb2YgYnJvYWRjYXN0KS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLQo+IFRJUCAxOiBpZiBwb3N0aW5nL3JlYWRpbmcgdGhyb3VnaCBVc2Vu ZXQsIHBsZWFzZSBzZW5kIGFuIGFwcHJvcHJpYXRlCj4gc3Vic2NyaWJlLW5vbWFpbCBjb21tYW5k IHRvIG1ham9yZG9tb0Bwb3N0Z3Jlc3FsLm9yZyBzbyB0aGF0IHlvdXIKPiBtZXNzYWdlIGNhbiBn ZXQgdGhyb3VnaCB0byB0aGUgbWFpbGluZyBsaXN0IGNsZWFubHkKPiAKCgoKLS0gCndpdGggcmVn YXJkcywKUy5HbmFuYXZlbApTYXR5YW0gQ29tcHV0ZXIgU2VydmljZXMgTHRkLgo= ------=_Part_1317_19584722.1126778284447 Content-Type: text/html; charset=WINDOWS-1252 Content-Transfer-Encoding: base64 Content-Disposition: inline Y29hbGVzY2UoTkVXLmVuZF9kYXRlICwgT0xELmVuZF9kYXRlKSB3aWxsIHNvbHZlIHRoZSBpc3N1 ZS48YnI+PGJyPjxkaXY+PHNwYW4gY2xhc3M9ImdtYWlsX3F1b3RlIj5PbiA5LzE1LzA1LCA8YiBj bGFzcz0iZ21haWxfc2VuZGVybmFtZSI+TmVpbCBTYXVuZGVyczwvYj4gJmx0OzxhIGhyZWY9Im1h aWx0bzpuLmouc2F1bmRlcnNAZ21haWwuY29tIj5uLmouc2F1bmRlcnNAZ21haWwuY29tCjwvYT4m Z3Q7IHdyb3RlOjwvc3Bhbj48YmxvY2txdW90ZSBjbGFzcz0iZ21haWxfcXVvdGUiIHN0eWxlPSJi b3JkZXItbGVmdDogMXB4IHNvbGlkIHJnYigyMDQsIDIwNCwgMjA0KTsgbWFyZ2luOiAwcHQgMHB0 IDBwdCAwLjhleDsgcGFkZGluZy1sZWZ0OiAxZXg7Ij5IaSw8YnI+PGJyPkkndmUgcnVuIGluIHRv IGEgc21hbGwgcHJvYmxlbSB3aGVuIHdyaXRpbmcgYSB0cmlnZ2VyLjxicj48YnI+CkZvciBzaW1w bGljaXRpZXMgc2FrZSBsZXRzIHNheSB0aGF0IEkgaGF2ZSAyIHRhYmxlcyCWICdib29raW5ncycg YW5kPGJyPid1bmF2YWlsYWJsZV9wZXJpb2RzJy4gQm90aCBoYXZlIGNvbHVtbnMgJ3N0YXJ0X2Rh dGUnLCdlbmRfZGF0ZScsIGFuZDxicj4ncHJvcGVydHlfaWQnLjxicj48YnI+SSBoYXZlIHdyaXR0 ZW4gYSB0cmlnZ2VyIHRoYXQgaXMgZmlyZWQgb24gaW5zZXJ0cyBhbmQgdXBkYXRlcyBmb3IgYm90 aAo8YnI+dGFibGVzIHRoYXQgc2ltcGx5IGVuc3VyZXMgdGhhdCBubyBpbnRlcnZhbHMgKGRlZmlu ZWQgYnkgc3RhcnRfZGF0ZTxicj5hbmQgZW5kX2RhdGUpIG92ZXJsYXAgZm9yIHRoZSBzYW1lIHBy b3BlcnR5IGFjcm9zcyBib3RoIHRhYmxlcy48YnI+PGJyPkl0IHdvcmtzIHNpbXBseSBieSBkb2lu ZyBhIFNFTEVDVCB1c2luZyB0aGUgT1ZFUkxBUCBrZXl3b3JkIG9uPGJyPk5FVy5zdGFydF9kYXRl CiwgYW5kIE5FVy5lbmRfZGF0ZSBmb3IgYm90aCB0YWJsZXMgKElnbm9yaW5nIHRoZSByZWNvcmQ8 YnI+YmVpbmcgbW9kaWZpZWQpLiBUaGlzIHdvcmtzIGZpbmUgb24gaW5zZXJ0cyAoV2hlcmUgYm90 aCBzdGFydF9kYXRlIGFuZDxicj5lbmRfZGF0ZSBhcmUgc3BlY2lmaWVkKSwgYW5kIHVwZGF0ZXMg dGhhdCBtb2RpZnkgYm90aCBzdGFydF9kYXRlIGFuZDxicj5lbmRfZGF0ZSwgYnV0IGZvciB1cGRh dGVzIHdoZXJlIEkgb25seSB1cGRhdGUgJ3N0YXJ0X2RhdGUnLCBmb3IKPGJyPmV4YW1wbGUsIHRo ZSB0cmlnZ2VyIGZhaWxzIGJlY2F1c2UgTkVXLmVuZF9kYXRlIGlzIGVtcHR5Ljxicj48YnI+V2hh dHMgdGhlIGJlc3Qgd2F5IGFyb3VuZCB0aGlzPzxicj48YnI+SSd2ZSB0cmllZCB0byB3cml0ZSBz b21ldGhpbmcgYWxvbmcgdGhlIGxpbmVzIG9mIHRoZSBmb2xsb3dpbmc6PGJyPjxicj5ERUNMQVJF PGJyPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwO3NkYXRlIERBVEU7PGJyPiZuYnNwOyZuYnNwOyZu YnNwOyZuYnNwO2VkYXRlIERBVEU7Cjxicj48YnI+QkVHSU48YnI+Jm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7c2RhdGUgPSAoTkVXLnN0YXJ0X2RhdGUgSVMgTk9UIE5VTEwpID8gTkVXLnN0YXJ0X2Rh dGUgOiBPTEQuc3RhcnRfZGF0ZTs8YnI+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7ZWRhdGUgPSAo TkVXLmVuZF9kYXRlIElTIE5PVCBOVUxMKSA/IE5FVy5lbmRfZGF0ZSA6IE9MRC5lbmRfZGF0ZTs8 YnI+hTxicj48YnI+QnV0IGNvbmRpdGlvbmFsIGFzc2lnbm1lbnQgZG9lc24ndCBzZWVtIHRvIGJl IGNhdGVyZWQgZm9yLiBUaGUgbmV4dAo8YnI+YmVzdCB0aGluZyBpcyBhIHNlcmllcyBvZiBJRiBU SEVOIEVMU0lGIEVMU0Ugc3RhdGVtZW50cyB0byBhc3NpZ248YnI+c2RhdGUgYW5kIGVkYXRlLCBv ciBpcyB0aGVyZSBhbm90aGVyIHRlY2huaXF1ZSB0aGF0IEkndmUgbWlzc2VkPGJyPmVudGlyZWx5 Pzxicj48YnI+S2luZCBSZWdhcmRzLDxicj48YnI+TmVpbCBTYXVuZGVycy48YnI+PGJyPi0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLShlbmQgb2YgYnJvYWRjYXN0KS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLQo8YnI+VElQIDE6IGlmIHBvc3RpbmcvcmVhZGluZyB0aHJvdWdoIFVzZW5ldCwg cGxlYXNlIHNlbmQgYW4gYXBwcm9wcmlhdGU8YnI+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i c3A7Jm5ic3A7IHN1YnNjcmliZS1ub21haWwgY29tbWFuZCB0byA8YSBocmVmPSJtYWlsdG86bWFq b3Jkb21vQHBvc3RncmVzcWwub3JnIj5tYWpvcmRvbW9AcG9zdGdyZXNxbC5vcmc8L2E+IHNvIHRo YXQgeW91cjxicj4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgbWVzc2FnZSBj YW4gZ2V0IHRocm91Z2ggdG8gdGhlIG1haWxpbmcgbGlzdCBjbGVhbmx5Cjxicj48L2Jsb2NrcXVv dGU+PC9kaXY+PGJyPjxiciBjbGVhcj0iYWxsIj48YnI+LS0gPGJyPndpdGggcmVnYXJkcyw8YnI+ Uy5HbmFuYXZlbDxicj5TYXR5YW0gQ29tcHV0ZXIgU2VydmljZXMgTHRkLgo= ------=_Part_1317_19584722.1126778284447--