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 40A8F9DC9A3 for ; Sun, 5 Mar 2006 05:02:59 -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 56033-04 for ; Sun, 5 Mar 2006 05:03:00 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.199]) by postgresql.org (Postfix) with ESMTP id EEDA79DC9BE for ; Sun, 5 Mar 2006 05:02:56 -0400 (AST) Received: by nproxy.gmail.com with SMTP id x29so718945nfb for ; Sun, 05 Mar 2006 01:02:58 -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=DHn4vXuRVKkf+ihGD3S5mYuJiIzo581ndvGUj34DvSRYozepc4Eu8agdmAaRWLcF1Kz0eer1eYpKUq6VmJ4KhTevdXsVS2rWFlHsCwVTEq6AtWEwrPn1KpS6bh/DTcxJVjkwvOAJQHHOInumUYFQCv/rN1kMl62LFyqrcVQEhGM= Received: by 10.48.223.11 with SMTP id v11mr1890251nfg; Sun, 05 Mar 2006 01:02:58 -0800 (PST) Received: by 10.49.7.7 with HTTP; Sun, 5 Mar 2006 01:02:58 -0800 (PST) Message-ID: Date: Sun, 5 Mar 2006 12:02:58 +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.138 required=5 tests=[AWL=0.138] X-Spam-Score: 0.138 X-Spam-Level: X-Archive-Number: 200603/89 X-Sequence-Number: 24435 VW5mb3J0dW5hdGVseSwgYXQgdGhlIG1vbWVudCBQb3N0Z3JlcyBkb2Vzbid0IHN1cHBvcnQgc3Vi cXVlcmllcyBpbgpDSEVDSyBjb25zdHJhaW50cywgc28gaXQncyBzZWVtcyB0aGF0IHlvdSBzaG91 bGQgdXNlIHRyaWdnZXIgdG8gY2hlY2sKd2hhdCB5b3UgbmVlZCwgc210aCBsaWtlIHRoaXM6CgpD UkVBVEUgT1IgUkVQTEFDRSBGVU5DVElPTiBmb29fY2hlY2soKSBSRVRVUk5TIHRyaWdnZXIgQVMg JEJPRFkkCkJFR0lOCiAgICBJRiBORVcuYWN0aXZlID0gVFJVRSBBTkQgTkVXLmlkIElOICgKICAg ICAgICBTRUxFQ1QgaWQgRlJPTSBmb28gV0hFUkUgYWN0aXZlID0gVFJVRSBBTkQgaWQgPSBORVcu aWQKICAgICkgVEhFTgogICAgICAgIFJBSVNFIEVYQ0VQVElPTiAnVW5pcXVlbmVzcyB2aW9sYXRp b24gb24gY29sdW1uIGlkICglKScsIE5FVy5pZDsKICAgIEVORCBJRjsKCiAgICBSRVRVUk4gTkVX OwpFTkQKJEJPRFkkICBMQU5HVUFHRSBwbHBnc3FsOwoKQ1JFQVRFIFRSSUdHRVIgZm9vX2NoZWNr IEJFRk9SRSBJTlNFUlQgT1IgVVBEQVRFIE9OIGZvbwogICAgRk9SIEVBQ0ggUk9XIEVYRUNVVEUg UFJPQ0VEVVJFIGZvb19jaGVjaygpOwoKT24gMy81LzA2LCBKZWZmIEZyb3N0IDxqZWZmQGZyb3N0 Y29uc3VsdGluZ2xsYy5jb20+IHdyb3RlOgo+IEkgaGF2ZSBhIHRhYmxlIHdpdGggdGhlIGZvbGxv d2luZyBzdHJ1Y3R1cmU6Cj4KPiAgICAgQ29sdW1uICAgfCAgVHlwZSAgIHwgICAgICAgTW9kaWZp ZXJzCj4gLS0tLS0tLS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQo+ICAg YWN0aXZlICAgICB8IGJvb2xlYW4gfCBub3QgbnVsbCBkZWZhdWx0IHRydWUKPiAgIGlkICAgICAg ICAgfCBpbnRlZ2VyIHwgbm90IG51bGwKPiAob3RoZXIgY29sdW1ucyBsZWZ0IG91dCkKPgo+IEFu ZCB3b3VsZCBsaWtlIHRvIG1ha2UgYSB1bmlxdWUgY29uc3RyYWludCB3aGljaCB3b3VsZCBvbmx5 IGNoZWNrIHRoZQo+IHVuaXF1ZW5lc3Mgb2YgaWQgaWYgYWN0aXZlPXRydWUuCj4KPiBTbywgdGhl IGZvbGxvd2luZyB2YWx1ZXMgd291bGQgYmUgYWNjZXB0YWJsZToKPgo+ICgnZicsNSkKPiAoJ2Yn LDUpCj4gKCd0Jyw1KQo+Cj4gQnV0IHRoZXNlIHdvdWxkIG5vdCBiZToKPgo+ICgndCcsNSkKPiAo J3QnLDUpCj4KPiBCYXNpY2FsbHksIEkgd2FudCBzb21ldGhpbmcgbGlrZToKPiBBTFRFUiBUQUJM RSBiYXIgQUREIENPTlNUUkFJTlQgZm9vIFVOSVFVRShhY3RpdmUgKHdoZXJlIGFjdGl2ZT0ndCcp LGlkKQo+Cj4gQnV0IHRoZSBhYm92ZSBkb2VzIG5vdCBhcHBlYXIgdG8gZXhpc3QuICBJcyB0aGVy ZSBhIHNpbXBsZSB3YXkgdG8gY3JlYXRlIGEKPiBjaGVjayBjb25zdHJhaW50IGZvciB0aGlzIHR5 cGUgb2Ygc2l0dWF0aW9uLCBvciBkbyBJIG5lZWQgdG8gY3JlYXRlIGEgZnVuY3Rpb24KPiB0byBl dmFsIGEgY2hlY2sgY29uc3RyYWludD8KPgo+IC0tCj4gSmVmZiBGcm9zdCwgT3duZXIgICAgICAg PGplZmZAZnJvc3Rjb25zdWx0aW5nbGxjLmNvbT4KPiBGcm9zdCBDb25zdWx0aW5nLCBMTEMgICBo dHRwOi8vd3d3LmZyb3N0Y29uc3VsdGluZ2xsYy5jb20vCj4gUGhvbmU6IDY1MC03ODAtNzkwOCAg ICAgRkFYOiA2NTAtNjQ5LTE5NTQKPgo+IC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLShlbmQg b2YgYnJvYWRjYXN0KS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQo+IFRJUCA1OiBkb24ndCBm b3JnZXQgdG8gaW5jcmVhc2UgeW91ciBmcmVlIHNwYWNlIG1hcCBzZXR0aW5ncwo+CgoKLS0KQmVz dCByZWdhcmRzLApOaWtvbGF5Cg==