Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 474F71337B5D for ; Tue, 11 Jan 2011 16:08:17 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 98386-10 for ; Tue, 11 Jan 2011 20:08:09 +0000 (UTC) X-Greylist: delayed 00:07:05.628401 by SQLgrey-1.7.6 Received: from forward4.mail.yandex.net (forward4.mail.yandex.net [77.88.46.9]) by mail.postgresql.org (Postfix) with ESMTP id A34A31337B64 for ; Tue, 11 Jan 2011 16:08:08 -0400 (AST) Received: from web61.yandex.ru (web61.yandex.ru [77.88.46.52]) by forward4.mail.yandex.net (Yandex) with ESMTP id A09D26AD8EE7; Tue, 11 Jan 2011 23:00:57 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex.ru; s=mail; t=1294776057; bh=3HChygDGS0XAVYOFUP9dmtyyWn2ZWkYh+kKKxTpKgvo=; h=From:To:In-Reply-To:References:Subject:MIME-Version:Message-Id: Date:Content-Transfer-Encoding:Content-Type; b=PQdwnjEHZ8I2Hj2XP1PEOq2/xwumT9IUahTAfAFJcHc1XEED7jc4Ku/ls1RFaCQLa Zq9lxpdivOwdRBoPy7LQ52l5WLBZ3FZ/zfkjVVXvZmlHFi3lovlYBtUelbPWNOdpFe N2oWOXvel4nQEgs7nQUIBTsatVBUizyoYnujZruU= Received: from localhost (localhost.localdomain [127.0.0.1]) by web61.yandex.ru (Yandex) with ESMTP id 90280BC8075; Tue, 11 Jan 2011 23:00:57 +0300 (MSK) Received: from z10-13.opera-mini.net (z10-13.opera-mini.net [82.145.208.144]) by mail.yandex.ru with HTTP; Tue, 11 Jan 2011 23:00:55 +0300 From: msi77 To: "Ozer, Pam" ,pgsql-sql@postgresql.org In-Reply-To: <216FFB77CBFAEE4B8EE4DF0A939FF1D1018440@mail-001.corp.automotive.com> References: <216FFB77CBFAEE4B8EE4DF0A939FF1D1018440@mail-001.corp.automotive.com> Subject: Re: Getting top 2 by Category MIME-Version: 1.0 Message-Id: <143611294776056@web61.yandex.ru> Date: Tue, 11 Jan 2011 23:00:55 +0300 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Content-Transfer-Encoding: base64 Content-Type: text/plain; charset=koi8-r X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.925 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FREEMAIL_ENVFROM_END_DIGIT=1.553, FREEMAIL_FROM=0.001, FSL_RU_URL=2.271, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: * X-Archive-Number: 201101/28 X-Sequence-Number: 34975 VGhlcmUgc29tZSB3YXlzIHRvIGRvIHRoaXMgaW4gb25lIHF1ZXJ5LiBMb29rIGhlcmU6DQpodHRw Oi8vd3d3LnNxbC1leC5ydS9oZWxwL3NlbGVjdDE2LnBocA0KDQotLS0tLS0tLS0tLS0tLS0NCjEx LjAxLjExLCAyMjowMCwgIk96ZXIsIFBhbSIgPHBvemVyQGF1dG9tb3RpdmUuY29tPjo+IFRoaXMg aXMgcHJvYmFibHkgdmVyeSBzaW1wbGUgYnV0IEkgYW0gZHJhd2luZyBhIGJsYW5rLpogRG8gSSBu ZWVkIHRvIGNyZWF0ZSBhIGN1cnNvciB0byBpdGVyYXRlIHRocm91Z2ggYSB0YWJsZSB0byBncmFi IHRoZSB0b3AgMiBtYWdhemluZXMgcGVyIGNhdGVnb3J5P5ogSGVyZSBpcyBteSB0YWJsZSBhbmQg c29tZSBkYXRhIC6aIFRoZSByZXN1bHRzIEkgbmVlZCBhcmUgYXQgdGhlmiBib3R0b20umiBBbnkg aGVscCB3b3VsZCBiZSBncmVhdGx5IGFwcHJlY2lhdGVkOppDUkVBVEUgVEFCTEUgbWFnYXppbmVj YXRlZ29yeSiaIG1hZ2F6aW5lY2F0ZWdvcnlpZCBzbWFsbGludCBOT1QgTlVMTCAsmiBtYWdhemlu ZWlkIHNtYWxsaW50LJogY2F0ZWdvcnlpZCBzbWFsbGludCk7mklOU0VSVCBJTlRPIG1hZ2F6aW5l Y2F0ZWdvcnkompqampqampqampogbWFnYXppbmVjYXRlZ29yeWlkLCBtYWdhemluZWlkLCBjYXRl Z29yeWlkKZqamiBWQUxVRVMgKDEsIDIsIDMpO5qaSU5TRVJUIElOVE8gbWFnYXppbmVjYXRlZ29y eSiampqampqampqamiBtYWdhemluZWNhdGVnb3J5aWQsIG1hZ2F6aW5laWQsIGNhdGVnb3J5aWQp mpqaIFZBTFVFUyAoMiwgOCwgMyk7mppJTlNFUlQgSU5UTyBtYWdhemluZWNhdGVnb3J5KJqampqa mpqampqaIG1hZ2F6aW5lY2F0ZWdvcnlpZCwgbWFnYXppbmVpZCwgY2F0ZWdvcnlpZCmampogVkFM VUVTICgzIDksIDMpO5qaSU5TRVJUIElOVE8gbWFnYXppbmVjYXRlZ29yeSiampqampqampqamiBt YWdhemluZWNhdGVnb3J5aWQsIG1hZ2F6aW5laWQsIGNhdGVnb3J5aWQpmpqaIFZBTFVFUyAoNCwg MTAsIDQpO5qamklOU0VSVCBJTlRPIG1hZ2F6aW5lY2F0ZWdvcnkompqampqampqampogbWFnYXpp bmVjYXRlZ29yeWlkLCBtYWdhemluZWlkLCBjYXRlZ29yeWlkKZqamiBWQUxVRVMgKDUsIDExLCA0 KTuaSU5TRVJUIElOVE8gbWFnYXppbmVjYXRlZ29yeSiampqampqampqamiBtYWdhemluZWNhdGVn b3J5aWQsIG1hZ2F6aW5laWQsIGNhdGVnb3J5aWQpmpqaIFZBTFVFUyAoNiwgMTIsNCk7mpqaVGhl IHJlc3VsdHMgSSB3YW50IGFyZUNhdGVnb3J5SUSaIE1hZ2F6aW5lSUQzIDIzIDg0IDEwNCAxMZqa mlBhbSBPemVyPg==