X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 56D799DC8AE for ; Sun, 5 Mar 2006 05:49:26 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 62651-06 for ; Sun, 5 Mar 2006 05:49:27 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.202]) by postgresql.org (Postfix) with ESMTP id B12919DC856 for ; Sun, 5 Mar 2006 05:49:23 -0400 (AST) Received: by nproxy.gmail.com with SMTP id k26so718276nfc for ; Sun, 05 Mar 2006 01:49:25 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=R8GYFdV0+tfy9s/vLolSf46IPh9VUcqfOHEc2ag5cZy+MbjZ7TKYNg2aOpaMzQ+hWAJPXGV3S9n3y6fRmwPSe2nKqwh8N12UKRZyBTDlKAkP2jo73xqDPVDdfAJQVNxpuMRlE+oguUoi5xnN77yk/xFekfNDQQ8P1DoQKP4x8BI= Received: by 10.49.41.4 with SMTP id t4mr1892596nfj; Sun, 05 Mar 2006 01:49:24 -0800 (PST) Received: by 10.49.7.7 with HTTP; Sun, 5 Mar 2006 01:49:24 -0800 (PST) Message-ID: Date: Sun, 5 Mar 2006 12:49:24 +0300 From: "Nikolay Samokhvalov" Reply-To: nikolay@samokhvalov.com To: pgsql-sql@postgresql.org, "Jeff Frost" Subject: Re: Check/unique constraint question In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 Content-Disposition: inline References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.802 required=5 tests=[AWL=-0.530, RCVD_IN_BL_SPAMCOP_NET=1.332, UPPERCASE_25_50=0] X-Spam-Score: 0.802 X-Spam-Level: X-Archive-Number: 200603/90 X-Sequence-Number: 24436 anVzdCBhIGJldHRlciB3YXkgKHdvcmthcm91bmQgZm9yIHN1YnF1ZXJpZXMgaW4gY2hlY2sgY29u c3RyYWludHMuLi4pOgoKQ1JFQVRFIE9SIFJFUExBQ0UgRlVOQ1RJT04gaWRfaXNfdmFsaWQoCiAg ICB2YWwgSU5URUdFUgopIFJFVFVSTlMgYm9vbGVhbiBBUyAkQk9EWSQKQkVHSU4KICAgIElGIHZh bCBJTiAoCiAgICAgICAgU0VMRUNUIGlkIEZST00gZm9vIFdIRVJFIGFjdGl2ZSA9IFRSVUUgQU5E IGlkID0gdmFsCiAgICApIFRIRU4KICAgICAgICBSRVRVUk4gRkFMU0U7CiAgICBFTFNFCiAgICAg ICAgUkVUVVJOIFRSVUU7CiAgICBFTkQgSUY7CkVORAokQk9EWSQgIExBTkdVQUdFIHBscGdzcWw7 CkFMVEVSIFRBQkxFIGZvbyBBREQgQ09OU1RSQUlOVCBDX2Zvb19pbmlxX2lmX3RydWUgQ0hFQ0sg KGFjdGl2ZSA9CkZBTFNFIE9SIGlkX2lzX3ZhbGlkKGlkKSk7CgpPbiAzLzUvMDYsIE5pa29sYXkg U2Ftb2todmFsb3YgPHNhbW9raHZhbG92QGdtYWlsLmNvbT4gd3JvdGU6Cj4gVW5mb3J0dW5hdGVs eSwgYXQgdGhlIG1vbWVudCBQb3N0Z3JlcyBkb2Vzbid0IHN1cHBvcnQgc3VicXVlcmllcyBpbgo+ IENIRUNLIGNvbnN0cmFpbnRzLCBzbyBpdCdzIHNlZW1zIHRoYXQgeW91IHNob3VsZCB1c2UgdHJp Z2dlciB0byBjaGVjawo+IHdoYXQgeW91IG5lZWQsIHNtdGggbGlrZSB0aGlzOgo+Cj4gQ1JFQVRF IE9SIFJFUExBQ0UgRlVOQ1RJT04gZm9vX2NoZWNrKCkgUkVUVVJOUyB0cmlnZ2VyIEFTICRCT0RZ JAo+IEJFR0lOCj4gICAgIElGIE5FVy5hY3RpdmUgPSBUUlVFIEFORCBORVcuaWQgSU4gKAo+ICAg ICAgICAgU0VMRUNUIGlkIEZST00gZm9vIFdIRVJFIGFjdGl2ZSA9IFRSVUUgQU5EIGlkID0gTkVX LmlkCj4gICAgICkgVEhFTgo+ICAgICAgICAgUkFJU0UgRVhDRVBUSU9OICdVbmlxdWVuZXNzIHZp b2xhdGlvbiBvbiBjb2x1bW4gaWQgKCUpJywgTkVXLmlkOwo+ICAgICBFTkQgSUY7Cj4KPiAgICAg UkVUVVJOIE5FVzsKPiBFTkQKPiAkQk9EWSQgIExBTkdVQUdFIHBscGdzcWw7Cj4KPiBDUkVBVEUg VFJJR0dFUiBmb29fY2hlY2sgQkVGT1JFIElOU0VSVCBPUiBVUERBVEUgT04gZm9vCj4gICAgIEZP UiBFQUNIIFJPVyBFWEVDVVRFIFBST0NFRFVSRSBmb29fY2hlY2soKTsKPgo+IE9uIDMvNS8wNiwg SmVmZiBGcm9zdCA8amVmZkBmcm9zdGNvbnN1bHRpbmdsbGMuY29tPiB3cm90ZToKPiA+IEkgaGF2 ZSBhIHRhYmxlIHdpdGggdGhlIGZvbGxvd2luZyBzdHJ1Y3R1cmU6Cj4gPgo+ID4gICAgIENvbHVt biAgIHwgIFR5cGUgICB8ICAgICAgIE1vZGlmaWVycwo+ID4gLS0tLS0tLS0tLS0tKy0tLS0tLS0t LSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQo+ID4gICBhY3RpdmUgICAgIHwgYm9vbGVhbiB8IG5v dCBudWxsIGRlZmF1bHQgdHJ1ZQo+ID4gICBpZCAgICAgICAgIHwgaW50ZWdlciB8IG5vdCBudWxs Cj4gPiAob3RoZXIgY29sdW1ucyBsZWZ0IG91dCkKPiA+Cj4gPiBBbmQgd291bGQgbGlrZSB0byBt YWtlIGEgdW5pcXVlIGNvbnN0cmFpbnQgd2hpY2ggd291bGQgb25seSBjaGVjayB0aGUKPiA+IHVu aXF1ZW5lc3Mgb2YgaWQgaWYgYWN0aXZlPXRydWUuCj4gPgo+ID4gU28sIHRoZSBmb2xsb3dpbmcg dmFsdWVzIHdvdWxkIGJlIGFjY2VwdGFibGU6Cj4gPgo+ID4gKCdmJyw1KQo+ID4gKCdmJyw1KQo+ ID4gKCd0Jyw1KQo+ID4KPiA+IEJ1dCB0aGVzZSB3b3VsZCBub3QgYmU6Cj4gPgo+ID4gKCd0Jyw1 KQo+ID4gKCd0Jyw1KQo+ID4KPiA+IEJhc2ljYWxseSwgSSB3YW50IHNvbWV0aGluZyBsaWtlOgo+ ID4gQUxURVIgVEFCTEUgYmFyIEFERCBDT05TVFJBSU5UIGZvbyBVTklRVUUoYWN0aXZlICh3aGVy ZSBhY3RpdmU9J3QnKSxpZCkKPiA+Cj4gPiBCdXQgdGhlIGFib3ZlIGRvZXMgbm90IGFwcGVhciB0 byBleGlzdC4gIElzIHRoZXJlIGEgc2ltcGxlIHdheSB0byBjcmVhdGUgYQo+ID4gY2hlY2sgY29u c3RyYWludCBmb3IgdGhpcyB0eXBlIG9mIHNpdHVhdGlvbiwgb3IgZG8gSSBuZWVkIHRvIGNyZWF0 ZSBhIGZ1bmN0aW9uCj4gPiB0byBldmFsIGEgY2hlY2sgY29uc3RyYWludD8KPiA+Cj4gPiAtLQo+ ID4gSmVmZiBGcm9zdCwgT3duZXIgICAgICAgPGplZmZAZnJvc3Rjb25zdWx0aW5nbGxjLmNvbT4K PiA+IEZyb3N0IENvbnN1bHRpbmcsIExMQyAgIGh0dHA6Ly93d3cuZnJvc3Rjb25zdWx0aW5nbGxj LmNvbS8KPiA+IFBob25lOiA2NTAtNzgwLTc5MDggICAgIEZBWDogNjUwLTY0OS0xOTU0Cj4gPgo+ ID4gLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKGVuZCBvZiBicm9hZGNhc3QpLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tCj4gPiBUSVAgNTogZG9uJ3QgZm9yZ2V0IHRvIGluY3JlYXNlIHlv dXIgZnJlZSBzcGFjZSBtYXAgc2V0dGluZ3MKPiA+Cj4KPgo+IC0tCj4gQmVzdCByZWdhcmRzLAo+ IE5pa29sYXkKPgoKCi0tCkJlc3QgcmVnYXJkcywKTmlrb2xheQo=