Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 64308632A73 for ; Mon, 1 Feb 2010 10:04:58 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 86224-06 for ; Mon, 1 Feb 2010 14:04:39 +0000 (UTC) X-Greylist: delayed 00:10:00.684283 by SQLgrey-1.7.6 Received: from mail.scanlab.de (mail.scanlab.de [62.138.55.241]) by mail.postgresql.org (Postfix) with ESMTP id 59C0F632420 for ; Mon, 1 Feb 2010 10:04:46 -0400 (AST) Received: from unknown (HELO Exchange-Server.scanlab-intern.de) ([172.16.20.15]) by mail.scanlab-intern.de with ESMTP; 01 Feb 2010 14:54:43 +0100 Received: from Exchange-Server.scanlab-intern.de ([fe80::899b:4a53:8d4d:6c13]) by Exchange-Server.scanlab-intern.de ([fe80::899b:4a53:8d4d:6c13%10]) with mapi; Mon, 1 Feb 2010 14:54:43 +0100 From: Andreas Gaab To: "'8q5tmkyqry@sneakemail.com'" <8q5tmkyqry@sneakemail.com>, "pgsql-sql@postgresql.org" Date: Mon, 1 Feb 2010 14:50:44 +0100 Subject: Re: selecting rows tagged with "a" but not "b" Thread-Topic: [SQL] selecting rows tagged with "a" but not "b" Thread-Index: AcqjQ/h5D7zHsJsQTKa1tHWKk0vojwAARh4A Message-ID: <48DA836F3865C54B8FBF424A3B775AF6F8ED2A6D@Exchange-Server.scanlab-intern.de> References: <11366-1265031099-334353@sneakemail.com> In-Reply-To: <11366-1265031099-334353@sneakemail.com> Accept-Language: de-DE Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: de-DE Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.462 tagged_above=-10 required=5 tests=AWL=0.278, BAYES_20=-0.74 X-Spam-Level: X-Archive-Number: 201002/13 X-Sequence-Number: 33612 SGkgRGFycmVsbCwNCg0KU0VMRUNUIERJU1RJTkNUIGFydGljbGVJRCBGUk9NIHRhZ3MgV0hFUkUg dGFnID0gImEiIA0KRVhDRVBUDQpTRUxFQ1QgRElTVElOQ1QgYXJ0aWNsZUlEIEZST00gdGFncyBX SEVSRSB0YWcgPSAiYiI7DQoNClJlZ2FyZHMsDQoNCkFuZHJlYXMNCg0KLS0tLS1VcnNwcsO8bmds aWNoZSBOYWNocmljaHQtLS0tLQ0KVm9uOiBwZ3NxbC1zcWwtb3duZXJAcG9zdGdyZXNxbC5vcmcg W21haWx0bzpwZ3NxbC1zcWwtb3duZXJAcG9zdGdyZXNxbC5vcmddIEltIEF1ZnRyYWcgdm9uIDhx NXRta3lxcnlAc25lYWtlbWFpbC5jb20NCkdlc2VuZGV0OiBNb250YWcsIDEuIEZlYnJ1YXIgMjAx MCAxNDozMg0KQW46IHBnc3FsLXNxbEBwb3N0Z3Jlc3FsLm9yZw0KQmV0cmVmZjogW1NRTF0gc2Vs ZWN0aW5nIHJvd3MgdGFnZ2VkIHdpdGggImEiIGJ1dCBub3QgImIiDQoNCkhpLA0KDQpJIGhhdmUg YSB0d28gdGFibGVzOg0KDQphcnRpY2xlDQphcnRpY2xlSUQsIG5hbWUsIGNvbnRlbnQNCg0KdGFn cw0KYXJ0aWNsZUlELCB0YWcNCg0KSSB3YW50IHRvIGZpbmQgYWxsIGFydGljbGVzIHRoYXQgYXJl IHRhZ2dlZCB3aXRoICJhIiBidXQgbm90ICJiIg0KDQpob3cgZG8gSSBkbyB0aGlzPw0KDQp3aGF0 IEknZCBsaWtlIHRvIGRvIGlzOg0KDQo8d2lzaGZ1bCB0aGlua2luZz4NCnNlbGVjdCBhcnRpY2xl SUQgZnJvbSB0YWdzIHdoZXJlIHRhZz0iYSINClNVQlRSQUNUDQpzZWxlY3QgYXJ0aWNsZUlEIGZy b20gdGFncyB3aGVyZSB0YWI9ImIiDQo8L3dpc2hmdWwgdGhpbmtpbmc+DQoNCmhvdyBkbyBJIGRv IHRoaXMgaW4gcmVhbCBTUUw/DQoNCnRoYW5rcw0KDQpEYXJyZWxsDQoNCi0tIA0KU2VudCB2aWEg cGdzcWwtc3FsIG1haWxpbmcgbGlzdCAocGdzcWwtc3FsQHBvc3RncmVzcWwub3JnKQ0KVG8gbWFr ZSBjaGFuZ2VzIHRvIHlvdXIgc3Vic2NyaXB0aW9uOg0KaHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9y Zy9tYWlscHJlZi9wZ3NxbC1zcWwNCg==