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 167FCD7AB4 for ; Tue, 22 Nov 2005 01:55:16 -0400 (AST) 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 91339-08 for ; Tue, 22 Nov 2005 05:55:15 +0000 (GMT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.204]) by svr1.postgresql.org (Postfix) with ESMTP id 71688D6E94 for ; Tue, 22 Nov 2005 01:55:13 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 13so989364nzn for ; Mon, 21 Nov 2005 21:55:13 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Yvc/qgdXno0uz0Np2pJeKQKLEgKDcYIYK6084LAvwJONgqAj+ulZ+KB2l86FU8PcmzCHuSlQQZ8qCXh4Vw5MXtUKoJR4fE2h797AAIN2A+b+vdG6zHK7xlwrgoHywepcy3z7MH13+ifM3j0ymq/txsXB61VA4/sUcSiEy77JQk8= Received: by 10.36.80.14 with SMTP id d14mr3696478nzb; Mon, 21 Nov 2005 21:55:13 -0800 (PST) Received: by 10.36.8.4 with HTTP; Mon, 21 Nov 2005 21:55:13 -0800 (PST) Message-ID: <7d215b0c0511212155i53c44f0en3f91cd6bde3b2140@mail.gmail.com> Date: Tue, 22 Nov 2005 07:55:13 +0200 From: Samer Abukhait To: "Grigory O. Ptashko" Subject: Re: Please help to wite the constraint. Cc: pgsql-sql@postgresql.org In-Reply-To: <1229661878.20051120223209@bk.ru> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 Content-Disposition: inline References: <1229661878.20051120223209@bk.ru> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[UPPERCASE_25_50=0] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/187 X-Sequence-Number: 23438 SSBjYW4ndCB1bmRlcnN0YW5kIHdoeSB5b3UgYXJlIGRvaW5nIHRoaXMgYmlnIGN5Y2xlLi4gYnV0 IGNlcnRhaW5seQp3aGVuIGNvbnN0cmFpbnRzIGNhbid0IGhlbHAgeW91Li4geW91IGNhbiB1c2Ug dHJpZ2dlcnMgdG8gZW5mb3JjZQppbnRlZ3JpdHkuLgoKT24gMTEvMjAvMDUsIEdyaWdvcnkgTy4g UHRhc2hrbyA8dHJhbmNlckBiay5ydT4gd3JvdGU6Cj4gSGVsbG8sIGV2ZXJ5Ym9keSEKPgo+IEkg ZG9uJ3Qgd2hldGhlciBpdCBpcyBwb3NzaWJsZSB0byBkbyB0aGUgZm9sbG93aW5nIGJ1dCBhbnl3 YXkgSSBjYW4ndC4KPiBJIG5lZWQgdG8gd3JpdGUgYSBjb25zdHJhaW50IGFzIGRlc2NyaWJlZCBi ZWxvdy4KPiBIZXJlIGFyZSBmb3VyIHRhYmxlczoKPgo+Cj4gQ1JFQVRFIFRBQkxFIGNvdW50cmll cwo+IChpZCBTRVJJQUwsCj4gIG5hbWUgVkFSQ0hBUigyNTUpLAo+ICBQUklNQVJZIEtFWSAoaWQp Cj4gKTsKPgo+IENSRUFURSBUQUJMRSBjb3VudHJpZXNfbmFtZXMKPiAoaWQgSU5UIE5PVCBOVUxM LAo+ICBpZF9sYW5nIElOVCBOT1QgTlVMTCwKPiAgbmFtZSBWQVJDSEFSKDI1NSksCj4gIFBSSU1B UlkgS0VZIChpZCwgaWRfbGFuZyksCj4gIEZPUkVJR04gS0VZIChpZCkgUkVGRVJFTkNFUyBjb3Vu dHJpZXMgKGlkKSwKPiAgRk9SRUlHTiBLRVkgKGlkX2xhbmcpIFJFRkVSRU5DRVMgbGFuZyAoaWQp Cj4KPiApOwo+Cj4gQ1JFQVRFIFRBQkxFIGNvbnRhY3RfaW5mb19maWVsZHMKPiAoaWQgU0VSSUFM LAo+ICBuYW1lIFZBUkNIQVIoMjU1KSBOT1QgTlVMTCwKPiAgUFJJTUFSWSBLRVkgKGlkKQo+ICk7 Cj4KPiBDUkVBVEUgVEFCTEUgY29udGFjdF9pbmZvX3JlY29yZHMKPiAoaWRfdXNlciBJTlQgTk9U IE5VTEwsCj4gIGlkX2NpX2ZpZWxkIElOVCBOT1QgTlVMTCwKPiAgaWRfbGFuZyBJTlQgTk9UIE5V TEwsCj4gIHZhbHVlIFRFWFQsCj4gIFBSSU1BUlkgS0VZIChpZF91c2VyLCBpZF9jaV9maWVsZCwg aWRfbGFuZyksCj4gIEZPUkVJR04gS0VZIChpZF91c2VyKSBSRUZFUkVOQ0VTIHVzZXJzIChpZCks Cj4gIEZPUkVJR04gS0VZIChpZF9jaV9maWVsZCkgUkVGRVJFTkNFUyBjb250YWN0X2luZm9fZmll bGRzIChpZCksCj4gIEZPUkVJR04gS0VZIChpZF9sYW5nKSBSRUZFUkVOQ0VTIGxhbmcgKGlkKQo+ ICk7Cj4KPgo+Cj4gVGhlIGxhc3QgdGFibGUgY29udGFpbnMgY29udGFjdCBpbmZvcm1hdGlvbiBy ZWNvcmRzIG9mIGRpZmZlcmVudCB0eXBlcy4gVGhlc2UgdHlwZXMgYXJlIHRha2VuIGZyb20gdGhl IHRhYmxlIGNvbnRhY3RfaW5mb19maWVsZHMuIEluIHBhcnRpY3VsYXIsIHRoZXJlIGNhbiBiZSB0 aGUgdHlwZSAnY291bnRyeScgc2F5IHdpdGggaWQ9MS4gVGhlbiB0aGUgY29udGFjdF9pbmZvX3Jl Y29yZHMgdGFibGUgY2FuIGNvbnRhaW4gdGhlIGZvbGxvd2luZyBpbmZvOiBpZF9jaV9maWVsZD0x IGFuZCB0aGUgVkFMVUUgZmllbGQgbXVzdCBjb250YWluIGEgY291bnRyeSdzIG5hbWUgYnV0IE9O TFkgaWYgaXQgZXhpc3RzIGluIHRoZSBjb3VudHJpZXMgdGFibGUgKGNvbHVtbiAnbmFtZScpLiBT byBpdCB0dXJucyBvdXQgdG8gYmUgYSB3aWVyZCBmb3JlaWduIGtleS4gSXMgaXQgcG9zc2libGUg dG8gd3JpdGUgc3VjaCBhIGNvbnN0cmFpbnQ/Cj4KPiBUaGFua3MhCj4KPgo+IC0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLShlbmQgb2YgYnJvYWRjYXN0KS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLQo+IFRJUCAyOiBEb24ndCAna2lsbCAtOScgdGhlIHBvc3RtYXN0ZXIKPgo=