From leopard_ne@inbox.ru Mon Mar  14 14:20:23 2011
Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 50F4C133798E
	for <pgsql-ru-general-postgresql.org@mail.postgresql.org>;
	Mon, 14 Mar 2011 11:28:30 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 58905-05
	for <pgsql-ru-general-postgresql.org@mail.postgresql.org>;
	Mon, 14 Mar 2011 14:28:23 +0000 (UTC)
X-Greylist: delayed 00:07:52.901569 by SQLgrey-1.7.6
Received: from fallback3.mail.ru (fallback3.mail.ru [94.100.176.58])
	by mail.postgresql.org (Postfix) with ESMTP id E43891336FA7
	for <pgsql-ru-general@postgresql.org>;
	Mon, 14 Mar 2011 11:28:22 -0300 (ADT)
Received: from f261.mail.ru (f261.mail.ru [217.69.128.182])
	by fallback3.mail.ru (mPOP.Fallback_MX) with ESMTP id DF4AB602D2AE
	for <pgsql-ru-general@postgresql.org>;
	Mon, 14 Mar 2011 17:20:29 +0300 (MSK)
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=mail.ru;
	s=mail;
	h=Message-Id:Content-Type:Reply-To:Date:Mime-Version:Subject:To:From;
	bh=WK/VM7oCtc+aknJPsHaA1EYIt1owj1OD6Nr1bxN38Mw=;
	b=HaI2PrwXgd/up6rRAYETplII6hlDcfOMCMJyFOd/DbFNcqINCiKFEUAIvUSKN1BR/BW2MXI8UUVbH5a2juOWVl7e8pXjRy1OqWzq1ieGIk7NgeVmBP0aOTfifjGc8Z/a;
Received: from mail by f261.mail.ru with local id 1Pz8dD-00012t-00
	for pgsql-ru-general@postgresql.org; Mon, 14 Mar 2011 17:20:23 +0300
Received: from [213.160.145.74] by win.mail.ru with HTTP;
	Mon, 14 Mar 2011 17:20:23 +0300
From: =?koi8-r?Q?=EF=CC=C5=CB=D3_=CA_=F7=C1=D3=C9=CC=D8_=D7?=
	<leopard_ne@inbox.ru>
To: pgsql-ru-general@postgresql.org
Subject: 
 =?koi8-r?Q?=F3=CF=D2=D4=C9=D2=CF=D7=CB=C1_=D7_=D4=D2=C5=C2=D5=C5=CD=CF=CD_=D0=CF=D2=D1=C4=CB=C5?=
Mime-Version: 1.0
X-Mailer: mPOP Web-Mail 2.19
X-Originating-IP: [213.160.145.74]
Date: Mon, 14 Mar 2011 17:20:23 +0300
Reply-To: =?koi8-r?Q?=EF=CC=C5=CB=D3_=CA_=F7=C1=D3=C9=CC=D8_=D7?=
	<leopard_ne@inbox.ru>
Content-Type: multipart/alternative;
	boundary="--ALT--xhvFgvdg1300112423"
Message-Id: <E1Pz8dD-00012t-00.leopard_ne-inbox-ru@f261.mail.ru>
X-Spam: Not detected
X-Mras: Ok
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=4.382 tagged_above=-10 required=5 tests=BAYES_50=0.8,
	FREEMAIL_FROM=0.001, FSL_RU_URL=2.271, HTML_MESSAGE=0.001,
	RATWARE_MPOP_WEBMAIL=1.999, RCVD_IN_DNSWL_LOW=-0.7,
	T_TO_NO_BRKTS_FREEMAIL=0.01
X-Spam-Level: ****
X-Archive-Number: 201103/71
X-Sequence-Number: 1203


----ALT--xhvFgvdg1300112423
Content-Type: text/plain; charset=koi8-r
Content-Transfer-Encoding: 8bit

Есть такой запрос:
Select * from foo where catalog_id IN(2,3,6,1,4,66,44,23,45)

Возможно ли вывести результат в таком же порядке, как и условие в IN, тоесть первый елемент с  catalog_id == 2, второй - catalog_id == 3, третий - catalog_id == 6, четвертый - catalog_id == 1 и т.д. 

----ALT--xhvFgvdg1300112423
Content-Type: text/html; charset=koi8-r
Content-Transfer-Encoding: 8bit

<HTML><BODY>
Есть такой запрос:<br>Select * from foo where catalog_id IN(2,3,6,1,4,66,44,23,45)<br><br>Возможно ли вывести результат в таком же порядке, как и условие в IN, тоесть первый елемент с&nbsp;&nbsp;catalog_id == 2, второй -&nbsp;catalog_id == 3, третий -&nbsp;catalog_id == 6, четвертый -&nbsp;catalog_id == 1 и т.д.&nbsp;</BODY></HTML>

----ALT--xhvFgvdg1300112423--



From unera@debian.org Mon Mar  14 15:09:26 2011
Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 9326D1337B9D
	for <pgsql-ru-general-postgresql.org@mail.postgresql.org>;
	Mon, 14 Mar 2011 12:09:44 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 52001-03
	for <pgsql-ru-general-postgresql.org@mail.postgresql.org>;
	Mon, 14 Mar 2011 15:09:34 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from vdst.uvw.ru (vdst.uvw.ru [206.123.89.0])
	by mail.postgresql.org (Postfix) with ESMTP id 0B4F4133616B
	for <pgsql-ru-general@postgresql.org>;
	Mon, 14 Mar 2011 12:09:33 -0300 (ADT)
Received: from [10.255.1.66] (helo=apache.rbscorp.ru)
	by vdst.uvw.ru with esmtp (Exim 4.72) (envelope-from <dimka@uvw.ru>)
	id 1Pz9Oj-0000OU-4P
	for pgsql-ru-general@postgresql.org; Mon, 14 Mar 2011 18:09:32 +0300
Received: from dimka by apache.rbscorp.ru with local (Exim 4.72)
	(envelope-from <dimka@apache.rbscorp.ru>) id 1Pz9Og-0002vw-Es
	for pgsql-ru-general@postgresql.org; Mon, 14 Mar 2011 18:09:26 +0300
Date: Mon, 14 Mar 2011 18:09:26 +0300
From: "Dmitry E. Oboukhov" <unera@debian.org>
To: pgsql-ru-general@postgresql.org
Message-ID: <20110314150925.GA19356@apache.rbscorp.ru>
References: <E1Pz8dD-00012t-00.leopard_ne-inbox-ru@f261.mail.ru>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-ripemd160;
	protocol="application/pgp-signature"; boundary="RnlQjJ0d97Da+TV1"
Content-Disposition: inline
In-Reply-To: <E1Pz8dD-00012t-00.leopard_ne-inbox-ru@f261.mail.ru>
User-Agent: Mutt/1.5.21 (2010-09-15)
X-SA-Exim-Connect-IP: 10.255.1.66
X-SA-Exim-Mail-From: dimka@uvw.ru
Subject: Re: =?utf-8?B?0KHQvtGA?=
	=?utf-8?B?0YLQuNGA0L7QstC60LAg0LIg0YLRgNC10LHRg9C10LzQvtC8INC/0L7RgNGP?=
	=?utf-8?B?0LTQutC1?=
X-SA-Exim-Version: 4.2.1 (built Mon, 22 Mar 2010 06:51:10 +0000)
X-SA-Exim-Scanned: No (on vdst.uvw.ru); Unknown failure
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.79 tagged_above=-10 required=5 tests=BAYES_50=0.8,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201103/72
X-Sequence-Number: 1204


--RnlQjJ0d97Da+TV1
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

=D0=9E=D0=B9=D0=92=D0=B2> =D0=95=D1=81=D1=82=D1=8C =D1=82=D0=B0=D0=BA=D0=BE=
=D0=B9 =D0=B7=D0=B0=D0=BF=D1=80=D0=BE=D1=81:
=D0=9E=D0=B9=D0=92=D0=B2> Select * from foo where catalog_id IN(2,3,6,1,4,6=
6,44,23,45)

=D0=9E=D0=B9=D0=92=D0=B2> =D0=92=D0=BE=D0=B7=D0=BC=D0=BE=D0=B6=D0=BD=D0=BE =
=D0=BB=D0=B8 =D0=B2=D1=8B=D0=B2=D0=B5=D1=81=D1=82=D0=B8 =D1=80=D0=B5=D0=B7=
=D1=83=D0=BB=D1=8C=D1=82=D0=B0=D1=82 =D0=B2 =D1=82=D0=B0=D0=BA=D0=BE=D0=BC =
=D0=B6=D0=B5 =D0=BF=D0=BE=D1=80=D1=8F=D0=B4=D0=BA=D0=B5, =D0=BA=D0=B0=D0=BA=
 =D0=B8 =D1=83=D1=81=D0=BB=D0=BE=D0=B2=D0=B8=D0=B5 =D0=B2 IN, =D1=82=D0=BE=
=D0=B5=D1=81=D1=82=D1=8C
=D0=9E=D0=B9=D0=92=D0=B2> =D0=BF=D0=B5=D1=80=D0=B2=D1=8B=D0=B9 =D0=B5=D0=BB=
=D0=B5=D0=BC=D0=B5=D0=BD=D1=82 =D1=81  catalog_id =3D=3D 2, =D0=B2=D1=82=D0=
=BE=D1=80=D0=BE=D0=B9 - catalog_id =3D=3D 3, =D1=82=D1=80=D0=B5=D1=82=D0=B8=
=D0=B9
=D0=9E=D0=B9=D0=92=D0=B2> - catalog_id =3D=3D 6, =D1=87=D0=B5=D1=82=D0=B2=
=D0=B5=D1=80=D1=82=D1=8B=D0=B9 - catalog_id =3D=3D 1 =D0=B8 =D1=82.=D0=B4.

=D1=81=D0=BA=D0=BE=D1=80=D0=B5=D0=B5 =D0=B2=D1=81=D0=B5=D0=B3=D0=BE =D0=BD=
=D0=B5=D1=82. =D0=BA=D0=BE=D0=B3=D0=B4=D0=B0 =D1=82=D0=B0=D0=B1=D0=BB=D0=B8=
=D1=86=D0=B0 =D0=BF=D1=80=D0=BE=D1=81=D0=BC=D0=B0=D1=82=D1=80=D0=B8=D0=B2=
=D0=B0=D0=B5=D1=82=D1=81=D1=8F =D0=BD=D0=B0 =D0=BF=D1=80=D0=B5=D0=B4=D0=BC=
=D0=B5=D1=82 =D0=B2=D1=8B=D0=B1=D0=BE=D1=80=D0=BA=D0=B8
=D1=81=D1=82=D1=80=D0=BE=D0=BA =D1=82=D0=BE =D0=BF=D1=80=D0=BE=D0=B2=D0=B5=
=D1=80=D1=8F=D0=B5=D1=82=D1=81=D1=8F =D1=83=D1=81=D0=BB=D0=BE=D0=B2=D0=B8=
=D0=B5 WHERE, =D0=B0 =D1=82=D0=BE =D0=B2 =D0=BA=D0=B0=D0=BA=D0=BE=D0=BC =D0=
=BF=D0=BE=D1=80=D1=8F=D0=B4=D0=BA=D0=B5 =D1=8D=D1=82=D0=BE =D1=83=D1=81=D0=
=BB=D0=BE=D0=B2=D0=B8=D0=B5
=D0=BD=D0=B0=D0=BF=D0=B8=D1=81=D0=B0=D0=BD=D0=BE =D1=80=D0=BE=D0=BB=D0=B8 =
=D0=BD=D0=B5 =D0=B8=D0=B3=D1=80=D0=B0=D0=B5=D1=82, =D0=B2=D0=B0=D0=B6=D0=BD=
=D0=BE TRUE/FALSE =D0=BB=D0=B8 =D0=BE=D0=BD=D0=BE =D0=B2=D0=BE=D0=B7=D0=B2=
=D1=80=D0=B0=D1=89=D0=B0=D0=B5=D1=82.

=D0=BC=D0=BE=D0=B6=D0=BD=D0=BE =D1=81=D0=BE=D1=80=D1=82=D0=B8=D1=80=D0=BD=
=D1=83=D1=82=D1=8C =D0=B2 =D1=85=D1=80=D0=B0=D0=BD=D0=B8=D0=BC=D0=BE=D0=B9 =
=D0=BF=D1=80=D0=BE=D1=86=D0=B5=D0=B4=D1=83=D1=80=D0=B5 =D0=B8=D0=BB=D0=B8 =
=D0=BF=D0=BE=D1=81=D0=BB=D0=B5 =D0=B2=D1=8B=D0=B1=D0=BE=D1=80=D0=BA=D0=B8, =
=D0=B8=D0=BC=D1=85=D0=BE
--=20

=2E ''`.                               Dmitry E. Oboukhov
: :=E2=80=99  :   email: unera@debian.org jabber://UNera@uvw.ru
`. `~=E2=80=99              GPGKey: 1024D / F8E26537 2006-11-21
  `- 1B23 D4F8 8EC0 D902 0555  E438 AB8C 00CF F8E2 6537

--RnlQjJ0d97Da+TV1
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iEYEAREDAAYFAk1+L6UACgkQq4wAz/jiZTdBVwCgte8yUrxm2tnr8QBYjcf0LHPc
784An05CvI6XcLQE169hPIn2WhqyfvKn
=RfDy
-----END PGP SIGNATURE-----

--RnlQjJ0d97Da+TV1--



From dmitigr@gmail.com Mon Mar  14 17:00:18 2011
Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 158A01337BE9
	for <pgsql-ru-general-postgresql.org@mail.postgresql.org>;
	Mon, 14 Mar 2011 14:00:30 -0300 (ADT)
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 27795-07
	for <pgsql-ru-general-postgresql.org@mail.postgresql.org>;
	Mon, 14 Mar 2011 17:00:20 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-yw0-f46.google.com (mail-yw0-f46.google.com
	[209.85.213.46])
	by mail.postgresql.org (Postfix) with ESMTP id 539141337BE8
	for <pgsql-ru-general@postgresql.org>;
	Mon, 14 Mar 2011 14:00:19 -0300 (ADT)
Received: by ywj3 with SMTP id 3so2128808ywj.19
	for <pgsql-ru-general@postgresql.org>;
	Mon, 14 Mar 2011 10:00:18 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:in-reply-to:references:date
	:message-id:subject:from:to:cc:content-type;
	bh=bEZMxzjKisg8P2PAqYArOPzEERHUQZY5p49Rtlmhc2w=;
	b=Vt4MjVrCrioWaJgVx8npEixioKfI0y+LRcbTtB7WfFenadUNHFKEApYh2e5q04mNK2
	rKuT6z0vSJITaucTmaieqUu/cegTTBjfxWYr/KxamWuniy+JxrJwjqnJaXgA8wQRAudx
	T33YN2gZox3pMqUH+1g02XT+JlBeXFGjGZLUE=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=tqs88BCi5u5jyHhs0jK+uKKEIUal5FqzxLoBbpopv7VHMQh2ZejGj437ly9nDfJNPN
	zbJtvRUG02Vkmjo6JPpLkPK/1OBxOVuB670bu1zcvkSbE4VDajxCAuWmGMcom9QhMJgf
	giLVnFJieqNZfcdd39yRPPMG5KyhttJziCBYI=
MIME-Version: 1.0
Received: by 10.90.83.2 with SMTP id g2mr3472881agb.121.1300122018497; Mon, 14
	Mar 2011 10:00:18 -0700 (PDT)
Received: by 10.91.123.4 with HTTP; Mon, 14 Mar 2011 10:00:18 -0700 (PDT)
In-Reply-To: <E1Pz8dD-00012t-00.leopard_ne-inbox-ru@f261.mail.ru>
References: <E1Pz8dD-00012t-00.leopard_ne-inbox-ru@f261.mail.ru>
Date: Mon, 14 Mar 2011 20:00:18 +0300
Message-ID: <AANLkTi=dhU+g9NWEEpBS_fgWZHLynxXpAtiZTvEUEo=o@mail.gmail.com>
Subject: 
 =?UTF-8?B?UmU6IFtwZ3NxbC1ydS1nZW5lcmFsXSDQodC+0YDRgtC40YDQvtCy0LrQsCDQsiDRgtGA?=
	=?UTF-8?B?0LXQsdGD0LXQvNC+0Lwg0L/QvtGA0Y/QtNC60LU=?=
From: Dmitriy Igrishin <dmitigr@gmail.com>
To: =?UTF-8?B?0J7Qu9C10LrRgSDQuSDQktCw0YHQuNC70Ywg0LI=?= <leopard_ne@inbox.ru>
Cc: pgsql-ru-general@postgresql.org
Content-Type: multipart/alternative; boundary=00163628364413c4b5049e743f64
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=3.073 tagged_above=-10 required=5 tests=BAYES_50=0.8,
	FREEMAIL_FROM=0.001, FSL_RU_URL=2.271, HTML_MESSAGE=0.001
X-Spam-Level: ***
X-Archive-Number: 201103/73
X-Sequence-Number: 1205

--00163628364413c4b5049e743f64
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: base64

0J/RgNC40LLQtdGC0YHRgtCy0YPRjiwKCjE0INC80LDRgNGC0LAgMjAxMSDQsy4gMTc6MjAg0L/Q
vtC70YzQt9C+0LLQsNGC0LXQu9GMINCe0LvQtdC60YEg0Lkg0JLQsNGB0LjQu9GMINCyCjxsZW9w
YXJkX25lQGluYm94LnJ1PtC90LDQv9C40YHQsNC7OgoKPiDQldGB0YLRjCDRgtCw0LrQvtC5INC3
0LDQv9GA0L7RgToKPiBTZWxlY3QgKiBmcm9tIGZvbyB3aGVyZSBjYXRhbG9nX2lkIElOKDIsMyw2
LDEsNCw2Niw0NCwyMyw0NSkKPgo+INCS0L7Qt9C80L7QttC90L4g0LvQuCDQstGL0LLQtdGB0YLQ
uCDRgNC10LfRg9C70YzRgtCw0YIg0LIg0YLQsNC60L7QvCDQttC1INC/0L7RgNGP0LTQutC1LCDQ
utCw0Log0Lgg0YPRgdC70L7QstC40LUg0LIgSU4sCj4g0YLQvtC10YHRgtGMINC/0LXRgNCy0YvQ
uSDQtdC70LXQvNC10L3RgiDRgSAgY2F0YWxvZ19pZCA9PSAyLCDQstGC0L7RgNC+0LkgLSBjYXRh
bG9nX2lkID09IDMsINGC0YDQtdGC0LjQuQo+IC0gY2F0YWxvZ19pZCA9PSA2LCDRh9C10YLQstC1
0YDRgtGL0LkgLSBjYXRhbG9nX2lkID09IDEg0Lgg0YIu0LQuCj4K0JTQsNC90L3Rg9GOINC30LDQ
tNCw0YfRgyDQvNC+0LbQvdC+INGA0LXRiNC40YLRjCwg0LfQsNC80LXQvdC40LIgSU4g0L3QsCBK
T0lOLCDQvdCw0L/RgNC40LzQtdGAOgoKZG1pdGlncj0+ClNFTEVDVCBmb28uKiBGUk9NIChWQUxV
RVMoMSksKDIpLCgzKSwoNCksKDYpKSBBUyBmb28oY2F0YWxvZ19pZCkKICBKT0lOIChTRUxFQ1Qg
aWQudmFsLCByb3dfbnVtYmVyKCkgb3ZlcigpIEZST00gKFZBTFVFUygzKSwoMiksKDYpLCgxKSwo
NCkpCkFTIGlkKHZhbCkpIEFTIGlkCiAgT04gKGZvby5jYXRhbG9nX2lkID0gaWQudmFsKSBPUkRF
UiBCWSByb3dfbnVtYmVyOwogY2F0YWxvZ19pZAotLS0tLS0tLS0tLS0KICAgICAgICAgIDMKICAg
ICAgICAgIDIKICAgICAgICAgIDYKICAgICAgICAgIDEKICAgICAgICAgIDQKCtCSINGN0YLQvtC8
INC/0YDQuNC80LXRgNC1IGZvbyAtINC40YHRhdC+0LTQvdCw0Y8g0YLQsNCx0LvQuNGG0LAg0YEg
0LTQsNC90L3Ri9C80LgsCmlkIC0g0L/RgdC10LLQtNC+0YLQsNCx0LvQuNGG0LAg0YEgMi3QvNGP
INGB0YLQvtC70LHRhtCw0LzQuDog0LfQvdCw0YfQtdC90LjQtSAo0YHQvtCx0YHRgtCy0LXQvdC9
0L4gaWQpCtC4INC10LPQviDQv9C+0YDRj9C00LrQvtCy0YvQuSDQvdC+0LzQtdGALgoKLS0gCi8v
IERtaXRyaXkuCg==
--00163628364413c4b5049e743f64
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: base64

0J/RgNC40LLQtdGC0YHRgtCy0YPRjiw8YnI+PGJyPjxkaXYgY2xhc3M9ImdtYWlsX3F1b3RlIj4x
NCDQvNCw0YDRgtCwIDIwMTHCoNCzLiAxNzoyMCDQv9C+0LvRjNC30L7QstCw0YLQtdC70Ywg0J7Q
u9C10LrRgSDQuSDQktCw0YHQuNC70Ywg0LIgPHNwYW4gZGlyPSJsdHIiPiZsdDs8YSBocmVmPSJt
YWlsdG86bGVvcGFyZF9uZUBpbmJveC5ydSI+bGVvcGFyZF9uZUBpbmJveC5ydTwvYT4mZ3Q7PC9z
cGFuPiDQvdCw0L/QuNGB0LDQuzo8YnI+PGJsb2NrcXVvdGUgY2xhc3M9ImdtYWlsX3F1b3RlIiBz
dHlsZT0ibWFyZ2luOiAwcHQgMHB0IDBwdCAwLjhleDsgYm9yZGVyLWxlZnQ6IDFweCBzb2xpZCBy
Z2IoMjA0LCAyMDQsIDIwNCk7IHBhZGRpbmctbGVmdDogMWV4OyI+CjxkaXY+CtCV0YHRgtGMINGC
0LDQutC+0Lkg0LfQsNC/0YDQvtGBOjxicj5TZWxlY3QgKiBmcm9tIGZvbyB3aGVyZSBjYXRhbG9n
X2lkIElOKDIsMyw2LDEsNCw2Niw0NCwyMyw0NSk8YnI+PGJyPtCS0L7Qt9C80L7QttC90L4g0LvQ
uCDQstGL0LLQtdGB0YLQuCDRgNC10LfRg9C70YzRgtCw0YIg0LIg0YLQsNC60L7QvCDQttC1INC/
0L7RgNGP0LTQutC1LCDQutCw0Log0Lgg0YPRgdC70L7QstC40LUg0LIgSU4sINGC0L7QtdGB0YLR
jCDQv9C10YDQstGL0Lkg0LXQu9C10LzQtdC90YIg0YHCoMKgY2F0YWxvZ19pZCA9PSAyLCDQstGC
0L7RgNC+0LkgLcKgY2F0YWxvZ19pZCA9PSAzLCDRgtGA0LXRgtC40LkgLcKgY2F0YWxvZ19pZCA9
PSA2LCDRh9C10YLQstC10YDRgtGL0LkgLcKgY2F0YWxvZ19pZCA9PSAxINC4INGCLtC0LsKgPC9k
aXY+CjwvYmxvY2txdW90ZT48ZGl2PtCU0LDQvdC90YPRjiDQt9Cw0LTQsNGH0YMg0LzQvtC20L3Q
viDRgNC10YjQuNGC0YwsINC30LDQvNC10L3QuNCyIElOINC90LAgSk9JTiwg0L3QsNC/0YDQuNC8
0LXRgDo8YnI+PGJyPmRtaXRpZ3I9Jmd0Ozxicj5TRUxFQ1QgZm9vLiogRlJPTSAoVkFMVUVTKDEp
LCgyKSwoMyksKDQpLCg2KSkgQVMgZm9vKGNhdGFsb2dfaWQpPGJyPsKgIEpPSU4gKFNFTEVDVCBp
ZC52YWwsIHJvd19udW1iZXIoKSBvdmVyKCkgRlJPTSAoVkFMVUVTKDMpLCgyKSwoNiksKDEpLCg0
KSkgQVMgaWQodmFsKSkgQVMgaWQ8YnI+CsKgIE9OIChmb28uY2F0YWxvZ19pZCA9IGlkLnZhbCkg
T1JERVIgQlkgcm93X251bWJlcjs8YnI+wqBjYXRhbG9nX2lkIDxicj4tLS0tLS0tLS0tLS08YnI+
wqDCoMKgwqDCoMKgwqDCoMKgIDM8YnI+wqDCoMKgwqDCoMKgwqDCoMKgIDI8YnI+wqDCoMKgwqDC
oMKgwqDCoMKgIDY8YnI+wqDCoMKgwqDCoMKgwqDCoMKgIDE8YnI+wqDCoMKgwqDCoMKgwqDCoMKg
IDQ8YnI+PC9kaXY+PC9kaXY+PGJyPtCSINGN0YLQvtC8INC/0YDQuNC80LXRgNC1IGZvbyAtINC4
0YHRhdC+0LTQvdCw0Y8g0YLQsNCx0LvQuNGG0LAg0YEg0LTQsNC90L3Ri9C80LgsPGJyPgppZCAt
INC/0YHQtdCy0LTQvtGC0LDQsdC70LjRhtCwINGBIDIt0LzRjyDRgdGC0L7Qu9Cx0YbQsNC80Lg6
INC30L3QsNGH0LXQvdC40LUgKNGB0L7QsdGB0YLQstC10L3QvdC+IGlkKTxicj7QuCDQtdCz0L4g
0L/QvtGA0Y/QtNC60L7QstGL0Lkg0L3QvtC80LXRgC48YnIgY2xlYXI9ImFsbCI+PGJyPi0tIDxi
cj4vLyBEbWl0cml5Ljxicj48YnI+PGJyPgo=
--00163628364413c4b5049e743f64--



From unera@debian.org Mon Mar  14 19:22:13 2011
Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 3E8D51337BF5
	for <pgsql-ru-general-postgresql.org@mail.postgresql.org>;
	Mon, 14 Mar 2011 16:39:30 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 29052-02-5
	for <pgsql-ru-general-postgresql.org@mail.postgresql.org>;
	Mon, 14 Mar 2011 19:39:22 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from vdst.uvw.ru (vdst.uvw.ru [206.123.89.0])
	by mail.postgresql.org (Postfix) with ESMTP id 80CE11337C92
	for <pgsql-ru-general@postgresql.org>;
	Mon, 14 Mar 2011 16:38:20 -0300 (ADT)
Received: from [10.255.1.66] (helo=apache.rbscorp.ru)
	by vdst.uvw.ru with esmtp (Exim 4.72) (envelope-from <dimka@uvw.ru>)
	id 1PzDaq-0007Jf-W3
	for pgsql-ru-general@postgresql.org; Mon, 14 Mar 2011 22:38:20 +0300
Received: from dimka by apache.rbscorp.ru with local (Exim 4.72)
	(envelope-from <dimka@apache.rbscorp.ru>) id 1PzDLJ-00043e-Kz
	for pgsql-ru-general@postgresql.org; Mon, 14 Mar 2011 22:22:13 +0300
Date: Mon, 14 Mar 2011 22:22:13 +0300
From: "Dmitry E. Oboukhov" <unera@debian.org>
To: pgsql-ru-general@postgresql.org
Message-ID: <20110314191250.GF19356@apache.rbscorp.ru>
References: <E1Pz8dD-00012t-00.leopard_ne-inbox-ru@f261.mail.ru>
	<AANLkTi=dhU+g9NWEEpBS_fgWZHLynxXpAtiZTvEUEo=o@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-ripemd160;
	protocol="application/pgp-signature"; boundary="+KJYzRxRHjYqLGl5"
Content-Disposition: inline
In-Reply-To: <AANLkTi=dhU+g9NWEEpBS_fgWZHLynxXpAtiZTvEUEo=o@mail.gmail.com>
User-Agent: Mutt/1.5.21 (2010-09-15)
X-SA-Exim-Connect-IP: 10.255.1.66
X-SA-Exim-Mail-From: dimka@uvw.ru
Subject: Re: Re: =?utf-8?B?W3Bn?=
	=?utf-8?B?c3FsLXJ1LWdlbmVyYWxdINCh0L7RgNGC0LjRgNC+0LLQutCwINCyINGC0YA=?=
	=?utf-8?B?0LXQsdGD0LXQvNC+0Lwg0L/QvtGA0Y/QtNC60LU=?=
X-SA-Exim-Version: 4.2.1 (built Mon, 22 Mar 2010 06:51:10 +0000)
X-SA-Exim-Scanned: No (on vdst.uvw.ru); Unknown failure
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=3.061 tagged_above=-10 required=5 tests=BAYES_50=0.8,
	FSL_RU_URL=2.271, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: ***
X-Archive-Number: 201103/74
X-Sequence-Number: 1206


--+KJYzRxRHjYqLGl5
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable


DI> 14 =D0=BC=D0=B0=D1=80=D1=82=D0=B0 2011=C2=A0=D0=B3. 17:20 =D0=BF=D0=BE=
=D0=BB=D1=8C=D0=B7=D0=BE=D0=B2=D0=B0=D1=82=D0=B5=D0=BB=D1=8C =D0=9E=D0=BB=
=D0=B5=D0=BA=D1=81 =D0=B9 =D0=92=D0=B0=D1=81=D0=B8=D0=BB=D1=8C =D0=B2 <leop=
ard_ne@inbox.ru>
DI> =D0=BD=D0=B0=D0=BF=D0=B8=D1=81=D0=B0=D0=BB:

DI> =D0=95=D1=81=D1=82=D1=8C =D1=82=D0=B0=D0=BA=D0=BE=D0=B9 =D0=B7=D0=B0=D0=
=BF=D1=80=D0=BE=D1=81:
DI> Select * from foo where catalog_id IN(2,3,6,1,4,66,44,23,45)

DI> =D0=92=D0=BE=D0=B7=D0=BC=D0=BE=D0=B6=D0=BD=D0=BE =D0=BB=D0=B8 =D0=B2=D1=
=8B=D0=B2=D0=B5=D1=81=D1=82=D0=B8 =D1=80=D0=B5=D0=B7=D1=83=D0=BB=D1=8C=D1=
=82=D0=B0=D1=82 =D0=B2 =D1=82=D0=B0=D0=BA=D0=BE=D0=BC =D0=B6=D0=B5 =D0=BF=
=D0=BE=D1=80=D1=8F=D0=B4=D0=BA=D0=B5, =D0=BA=D0=B0=D0=BA =D0=B8 =D1=83=D1=
=81=D0=BB=D0=BE=D0=B2=D0=B8=D0=B5 =D0=B2 IN,
DI> =D1=82=D0=BE=D0=B5=D1=81=D1=82=D1=8C =D0=BF=D0=B5=D1=80=D0=B2=D1=8B=D0=
=B9 =D0=B5=D0=BB=D0=B5=D0=BC=D0=B5=D0=BD=D1=82 =D1=81=C2=A0=C2=A0catalog_id=
 =3D=3D 2, =D0=B2=D1=82=D0=BE=D1=80=D0=BE=D0=B9 -=C2=A0catalog_id =3D=3D 3,=
 =D1=82=D1=80=D0=B5=D1=82=D0=B8=D0=B9
DI> -=C2=A0catalog_id =3D=3D 6, =D1=87=D0=B5=D1=82=D0=B2=D0=B5=D1=80=D1=82=
=D1=8B=D0=B9 -=C2=A0catalog_id =3D=3D 1 =D0=B8 =D1=82.=D0=B4.

DI> =D0=94=D0=B0=D0=BD=D0=BD=D1=83=D1=8E =D0=B7=D0=B0=D0=B4=D0=B0=D1=87=D1=
=83 =D0=BC=D0=BE=D0=B6=D0=BD=D0=BE =D1=80=D0=B5=D1=88=D0=B8=D1=82=D1=8C, =
=D0=B7=D0=B0=D0=BC=D0=B5=D0=BD=D0=B8=D0=B2 IN =D0=BD=D0=B0 JOIN, =D0=BD=D0=
=B0=D0=BF=D1=80=D0=B8=D0=BC=D0=B5=D1=80:

DI> dmitigr=3D>
DI> SELECT foo.* FROM (VALUES(1),(2),(3),(4),(6)) AS foo(catalog_id)
DI> JOIN (SELECT id.val, row_number() over() FROM (VALUES(3),(2),(6),(1),(4=
)) AS
DI> id(val)) AS id
DI> ON (foo.catalog_id =3D id.val) ORDER BY row_number;
DI> catalog_id
DI> ------------
DI> 3
DI> 2
DI> 6
DI> 1
DI> 4


=D0=BA=D1=81=D1=82=D0=B0=D1=82=D0=B8 unnest =D0=BA=D0=B0=D0=BA-=D1=82=D0=BE=
 =D0=B4=D0=B0=D0=B6=D0=B5 =D0=BF=D0=BE=D0=BA=D0=BE=D1=80=D0=BE=D1=87=D0=B5 =
=D0=B2=D1=8B=D0=B3=D0=BB=D1=8F=D0=B4=D0=B8=D1=82

SELECT
    foo.*

FROM
    unnest('{3,2,6,1,4}'::int[]) idt

JOIN
    foo ON catalog_id =3D idt

WHERE
    foo.id IS NOT NULL;

=D0=B8 =D0=BE=D1=82 =D1=81=D0=BE=D1=80=D1=82=D0=B8=D1=80=D0=BE=D0=B2=D0=BA=
=D0=B8 =D0=BC=D0=BE=D0=B6=D0=BD=D0=BE =D0=B8=D0=B7=D0=B1=D0=B0=D0=B2=D0=B8=
=D1=82=D1=8C=D1=81=D1=8F

=D1=85=D0=BE=D1=82=D1=8F =D0=BC=D0=BE=D0=B6=D0=B5=D1=82 =D0=BE=D0=BF=D1=82=
=D0=B8=D0=BC=D0=B8=D0=B7=D0=B0=D1=82=D0=BE=D1=80 =D0=B5=D0=B5 =D0=B8 =D1=81=
=D0=B0=D0=BC =D0=B2=D1=8B=D0=B1=D1=80=D0=BE=D1=81=D0=B8=D1=82.

DI> =D0=92 =D1=8D=D1=82=D0=BE=D0=BC =D0=BF=D1=80=D0=B8=D0=BC=D0=B5=D1=80=D0=
=B5 foo - =D0=B8=D1=81=D1=85=D0=BE=D0=B4=D0=BD=D0=B0=D1=8F =D1=82=D0=B0=D0=
=B1=D0=BB=D0=B8=D1=86=D0=B0 =D1=81 =D0=B4=D0=B0=D0=BD=D0=BD=D1=8B=D0=BC=D0=
=B8,
DI> id - =D0=BF=D1=81=D0=B5=D0=B2=D0=B4=D0=BE=D1=82=D0=B0=D0=B1=D0=BB=D0=B8=
=D1=86=D0=B0 =D1=81 2-=D0=BC=D1=8F =D1=81=D1=82=D0=BE=D0=BB=D0=B1=D1=86=D0=
=B0=D0=BC=D0=B8: =D0=B7=D0=BD=D0=B0=D1=87=D0=B5=D0=BD=D0=B8=D0=B5 (=D1=81=
=D0=BE=D0=B1=D1=81=D1=82=D0=B2=D0=B5=D0=BD=D0=BD=D0=BE id)
DI> =D0=B8 =D0=B5=D0=B3=D0=BE =D0=BF=D0=BE=D1=80=D1=8F=D0=B4=D0=BA=D0=BE=D0=
=B2=D1=8B=D0=B9 =D0=BD=D0=BE=D0=BC=D0=B5=D1=80.
--=20

=2E ''`.                               Dmitry E. Oboukhov
: :=E2=80=99  :   email: unera@debian.org jabber://UNera@uvw.ru
`. `~=E2=80=99              GPGKey: 1024D / F8E26537 2006-11-21
  `- 1B23 D4F8 8EC0 D902 0555  E438 AB8C 00CF F8E2 6537

--+KJYzRxRHjYqLGl5
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iEYEAREDAAYFAk1+aLIACgkQq4wAz/jiZTfP1ACeMmJEsnEJzwmVETZG6z5r2AYQ
yh4AoMEbF2Fonz84l60AlHoErIGgOd9E
=vUPP
-----END PGP SIGNATURE-----

--+KJYzRxRHjYqLGl5--



From unera@debian.org Mon Mar  14 19:43:03 2011
Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id A5A791337BE6
	for <pgsql-ru-general-postgresql.org@mail.postgresql.org>;
	Mon, 14 Mar 2011 16:43:15 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 54389-03
	for <pgsql-ru-general-postgresql.org@mail.postgresql.org>;
	Mon, 14 Mar 2011 19:43:08 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from vdst.uvw.ru (vdst.uvw.ru [206.123.89.0])
	by mail.postgresql.org (Postfix) with ESMTP id EBFB51337BEA
	for <pgsql-ru-general@postgresql.org>;
	Mon, 14 Mar 2011 16:43:07 -0300 (ADT)
Received: from [10.255.1.66] (helo=apache.rbscorp.ru)
	by vdst.uvw.ru with esmtp (Exim 4.72) (envelope-from <dimka@uvw.ru>)
	id 1PzDfU-00033m-RZ
	for pgsql-ru-general@postgresql.org; Mon, 14 Mar 2011 22:43:08 +0300
Received: from dimka by apache.rbscorp.ru with local (Exim 4.72)
	(envelope-from <dimka@apache.rbscorp.ru>) id 1PzDfT-0006NQ-O7
	for pgsql-ru-general@postgresql.org; Mon, 14 Mar 2011 22:43:03 +0300
Date: Mon, 14 Mar 2011 22:43:03 +0300
From: "Dmitry E. Oboukhov" <unera@debian.org>
To: pgsql-ru-general@postgresql.org
Message-ID: <20110314194302.GH19356@apache.rbscorp.ru>
References: <E1Pz8dD-00012t-00.leopard_ne-inbox-ru@f261.mail.ru>
	<AANLkTi=dhU+g9NWEEpBS_fgWZHLynxXpAtiZTvEUEo=o@mail.gmail.com>
	<20110314191250.GF19356@apache.rbscorp.ru>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-ripemd160;
	protocol="application/pgp-signature"; boundary="tVmo9FyGdCe4F4YN"
Content-Disposition: inline
In-Reply-To: <20110314191250.GF19356@apache.rbscorp.ru>
User-Agent: Mutt/1.5.21 (2010-09-15)
X-SA-Exim-Connect-IP: 10.255.1.66
X-SA-Exim-Mail-From: dimka@uvw.ru
Subject: Re: Re: =?utf-8?B?W3Bn?=
	=?utf-8?B?c3FsLXJ1LWdlbmVyYWxdINCh0L7RgNGC0LjRgNC+0LLQutCwINCyINGC0YA=?=
	=?utf-8?B?0LXQsdGD0LXQvNC+0Lwg0L/QvtGA0Y/QtNC60LU=?=
X-SA-Exim-Version: 4.2.1 (built Mon, 22 Mar 2010 06:51:10 +0000)
X-SA-Exim-Scanned: No (on vdst.uvw.ru); Unknown failure
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=3.061 tagged_above=-10 required=5 tests=BAYES_50=0.8,
	FSL_RU_URL=2.271, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: ***
X-Archive-Number: 201103/75
X-Sequence-Number: 1207


--tVmo9FyGdCe4F4YN
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On 22:22 Mon 14 Mar     , Dmitry E. Oboukhov wrote:

DI>> 14 =D0=BC=D0=B0=D1=80=D1=82=D0=B0 2011=C2=A0=D0=B3. 17:20 =D0=BF=D0=BE=
=D0=BB=D1=8C=D0=B7=D0=BE=D0=B2=D0=B0=D1=82=D0=B5=D0=BB=D1=8C =D0=9E=D0=BB=
=D0=B5=D0=BA=D1=81 =D0=B9 =D0=92=D0=B0=D1=81=D0=B8=D0=BB=D1=8C =D0=B2 <leop=
ard_ne@inbox.ru>
DI>> =D0=BD=D0=B0=D0=BF=D0=B8=D1=81=D0=B0=D0=BB:

DI>> =D0=95=D1=81=D1=82=D1=8C =D1=82=D0=B0=D0=BA=D0=BE=D0=B9 =D0=B7=D0=B0=
=D0=BF=D1=80=D0=BE=D1=81:
DI>> Select * from foo where catalog_id IN(2,3,6,1,4,66,44,23,45)

DI>> =D0=92=D0=BE=D0=B7=D0=BC=D0=BE=D0=B6=D0=BD=D0=BE =D0=BB=D0=B8 =D0=B2=
=D1=8B=D0=B2=D0=B5=D1=81=D1=82=D0=B8 =D1=80=D0=B5=D0=B7=D1=83=D0=BB=D1=8C=
=D1=82=D0=B0=D1=82 =D0=B2 =D1=82=D0=B0=D0=BA=D0=BE=D0=BC =D0=B6=D0=B5 =D0=
=BF=D0=BE=D1=80=D1=8F=D0=B4=D0=BA=D0=B5, =D0=BA=D0=B0=D0=BA =D0=B8 =D1=83=
=D1=81=D0=BB=D0=BE=D0=B2=D0=B8=D0=B5 =D0=B2 IN,
DI>> =D1=82=D0=BE=D0=B5=D1=81=D1=82=D1=8C =D0=BF=D0=B5=D1=80=D0=B2=D1=8B=D0=
=B9 =D0=B5=D0=BB=D0=B5=D0=BC=D0=B5=D0=BD=D1=82 =D1=81=C2=A0=C2=A0catalog_id=
 =3D=3D 2, =D0=B2=D1=82=D0=BE=D1=80=D0=BE=D0=B9 -=C2=A0catalog_id =3D=3D 3,=
 =D1=82=D1=80=D0=B5=D1=82=D0=B8=D0=B9
DI>> -=C2=A0catalog_id =3D=3D 6, =D1=87=D0=B5=D1=82=D0=B2=D0=B5=D1=80=D1=82=
=D1=8B=D0=B9 -=C2=A0catalog_id =3D=3D 1 =D0=B8 =D1=82.=D0=B4.

DI>> =D0=94=D0=B0=D0=BD=D0=BD=D1=83=D1=8E =D0=B7=D0=B0=D0=B4=D0=B0=D1=87=D1=
=83 =D0=BC=D0=BE=D0=B6=D0=BD=D0=BE =D1=80=D0=B5=D1=88=D0=B8=D1=82=D1=8C, =
=D0=B7=D0=B0=D0=BC=D0=B5=D0=BD=D0=B8=D0=B2 IN =D0=BD=D0=B0 JOIN, =D0=BD=D0=
=B0=D0=BF=D1=80=D0=B8=D0=BC=D0=B5=D1=80:

DI>> dmitigr=3D>
DI>> SELECT foo.* FROM (VALUES(1),(2),(3),(4),(6)) AS foo(catalog_id)
DI>> JOIN (SELECT id.val, row_number() over() FROM (VALUES(3),(2),(6),(1),(=
4)) AS
DI>> id(val)) AS id
DI>> ON (foo.catalog_id =3D id.val) ORDER BY row_number;
DI>> catalog_id
DI>> ------------
DI>> 3
DI>> 2
DI>> 6
DI>> 1
DI>> 4

Tprgpo> =D0=BA=D1=81=D1=82=D0=B0=D1=82=D0=B8 unnest =D0=BA=D0=B0=D0=BA-=D1=
=82=D0=BE =D0=B4=D0=B0=D0=B6=D0=B5 =D0=BF=D0=BE=D0=BA=D0=BE=D1=80=D0=BE=D1=
=87=D0=B5 =D0=B2=D1=8B=D0=B3=D0=BB=D1=8F=D0=B4=D0=B8=D1=82

Tprgpo> SELECT
Tprgpo> foo.*

Tprgpo> FROM
Tprgpo> unnest('{3,2,6,1,4}'::int[]) idt

Tprgpo> JOIN
Tprgpo> foo ON catalog_id =3D idt

Tprgpo> WHERE
Tprgpo> foo.id IS NOT NULL;

WHERE =D0=BA=D0=BE=D0=BD=D0=B5=D1=87=D0=BD=D0=BE =D0=B6=D0=B5 =D0=BD=D0=B5 =
=D0=BD=D1=83=D0=B6=D0=B5=D0=BD, WHERE =D1=8D=D1=82=D0=BE =D0=B5=D1=81=D0=BB=
=D0=B8 LEFT JOIN :)

--=20

=2E ''`.                               Dmitry E. Oboukhov
: :=E2=80=99  :   email: unera@debian.org jabber://UNera@uvw.ru
`. `~=E2=80=99              GPGKey: 1024D / F8E26537 2006-11-21
  `- 1B23 D4F8 8EC0 D902 0555  E438 AB8C 00CF F8E2 6537

--tVmo9FyGdCe4F4YN
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iEYEAREDAAYFAk1+b8YACgkQq4wAz/jiZTdMUACg7MXb1kcQaOaK0o+QMcBMGCD+
9REAoK6OERDeSg6xA8drAe++IZBm8jtf
=pT1c
-----END PGP SIGNATURE-----

--tVmo9FyGdCe4F4YN--



From dmitigr@gmail.com Mon Mar  14 19:51:52 2011
Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id C57BD1337BE9
	for <pgsql-ru-general-postgresql.org@mail.postgresql.org>;
	Mon, 14 Mar 2011 16:52:01 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 16508-04
	for <pgsql-ru-general-postgresql.org@mail.postgresql.org>;
	Mon, 14 Mar 2011 19:51:54 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-yi0-f46.google.com (mail-yi0-f46.google.com
	[209.85.218.46])
	by mail.postgresql.org (Postfix) with ESMTP id 838FD1337BE6
	for <pgsql-ru-general@postgresql.org>;
	Mon, 14 Mar 2011 16:51:53 -0300 (ADT)
Received: by yia27 with SMTP id 27so2172753yia.19
	for <pgsql-ru-general@postgresql.org>;
	Mon, 14 Mar 2011 12:51:53 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:in-reply-to:references:date
	:message-id:subject:from:to:cc:content-type;
	bh=Boi6bJGEfIgSiKwnLtubksB/7v/MyWtv4kttEGjxV1E=;
	b=G8wBxnyX9tEo6korwCjthWUSYqsElp9EWdcf6rDcBvdRCqqYXGKUeW95kWZ0VMhpB/
	n0otpBMu0wucKpsY30z7ZyLKJyyghOmJva0lGE/xsuNMAkpWNhBT+tnhcsRtPve5MLXc
	FRm+CdFxZT9nHiurtLlWsAoiQTDEAV/3x3zfw=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=IfRS1m82yyZctynUpAKAnbW5ynrTIE7+2XIBTvo7lScvqiFkitlvG3scyO1RJLDfQ3
	jqtOILH+3NFl9gHGD1z+yAad2DRPRegym60uVaj4ZzhqUy3WFzNH3bXKcHYVHDQFx8Bz
	c64t4wSgK2X330K1eCLkjnHwV3jQFy7HJ3rPk=
MIME-Version: 1.0
Received: by 10.91.3.10 with SMTP id f10mr3694567agi.40.1300132312793; Mon, 14
	Mar 2011 12:51:52 -0700 (PDT)
Received: by 10.91.123.4 with HTTP; Mon, 14 Mar 2011 12:51:52 -0700 (PDT)
In-Reply-To: <20110314191250.GF19356@apache.rbscorp.ru>
References: <E1Pz8dD-00012t-00.leopard_ne-inbox-ru@f261.mail.ru>
	<AANLkTi=dhU+g9NWEEpBS_fgWZHLynxXpAtiZTvEUEo=o@mail.gmail.com>
	<20110314191250.GF19356@apache.rbscorp.ru>
Date: Mon, 14 Mar 2011 22:51:52 +0300
Message-ID: <AANLkTi=VgG7DfCtpTitXneiS0eWrJPBmvOo14Q8ez9Pe@mail.gmail.com>
Subject: 
 =?UTF-8?B?UmU6IFtwZ3NxbC1ydS1nZW5lcmFsXSBSZTogW3Bnc3FsLXJ1LWdlbmVyYWxdINCh0L7RgA==?=
	=?UTF-8?B?0YLQuNGA0L7QstC60LAg0LIg0YLRgNC10LHRg9C10LzQvtC8INC/0L7RgNGP0LTQutC1?=
From: Dmitriy Igrishin <dmitigr@gmail.com>
To: "Dmitry E. Oboukhov" <unera@debian.org>
Cc: pgsql-ru-general@postgresql.org
Content-Type: multipart/alternative; boundary=0016363b8ba8aa419b049e76a44f
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=2.373 tagged_above=-10 required=5 tests=BAYES_50=0.8,
	FREEMAIL_FROM=0.001, FSL_RU_URL=2.271, HTML_MESSAGE=0.001,
	RCVD_IN_DNSWL_LOW=-0.7
X-Spam-Level: **
X-Archive-Number: 201103/76
X-Sequence-Number: 1208

--0016363b8ba8aa419b049e76a44f
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: base64

MTQg0LzQsNGA0YLQsCAyMDExINCzLiAyMjoyMiDQv9C+0LvRjNC30L7QstCw0YLQtdC70YwgRG1p
dHJ5IEUuIE9ib3VraG92Cjx1bmVyYUBkZWJpYW4ub3JnPtC90LDQv9C40YHQsNC7OgoKPgo+IERJ
PiAxNCDQvNCw0YDRgtCwIDIwMTEg0LMuIDE3OjIwINC/0L7Qu9GM0LfQvtCy0LDRgtC10LvRjCDQ
ntC70LXQutGBINC5INCS0LDRgdC40LvRjCDQsiA8Cj4gbGVvcGFyZF9uZUBpbmJveC5ydT4KPiBE
ST4g0L3QsNC/0LjRgdCw0Ls6Cj4KPiBEST4g0JXRgdGC0Ywg0YLQsNC60L7QuSDQt9Cw0L/RgNC+
0YE6Cj4gREk+IFNlbGVjdCAqIGZyb20gZm9vIHdoZXJlIGNhdGFsb2dfaWQgSU4oMiwzLDYsMSw0
LDY2LDQ0LDIzLDQ1KQo+Cj4gREk+INCS0L7Qt9C80L7QttC90L4g0LvQuCDQstGL0LLQtdGB0YLQ
uCDRgNC10LfRg9C70YzRgtCw0YIg0LIg0YLQsNC60L7QvCDQttC1INC/0L7RgNGP0LTQutC1LCDQ
utCw0Log0Lgg0YPRgdC70L7QstC40LUg0LIgSU4sCj4gREk+INGC0L7QtdGB0YLRjCDQv9C10YDQ
stGL0Lkg0LXQu9C10LzQtdC90YIg0YEgIGNhdGFsb2dfaWQgPT0gMiwg0LLRgtC+0YDQvtC5IC0g
Y2F0YWxvZ19pZCA9PSAzLAo+INGC0YDQtdGC0LjQuQo+IERJPiAtIGNhdGFsb2dfaWQgPT0gNiwg
0YfQtdGC0LLQtdGA0YLRi9C5IC0gY2F0YWxvZ19pZCA9PSAxINC4INGCLtC0Lgo+Cj4gREk+INCU
0LDQvdC90YPRjiDQt9Cw0LTQsNGH0YMg0LzQvtC20L3QviDRgNC10YjQuNGC0YwsINC30LDQvNC1
0L3QuNCyIElOINC90LAgSk9JTiwg0L3QsNC/0YDQuNC80LXRgDoKPgo+IERJPiBkbWl0aWdyPT4K
PiBEST4gU0VMRUNUIGZvby4qIEZST00gKFZBTFVFUygxKSwoMiksKDMpLCg0KSwoNikpIEFTIGZv
byhjYXRhbG9nX2lkKQo+IERJPiBKT0lOIChTRUxFQ1QgaWQudmFsLCByb3dfbnVtYmVyKCkgb3Zl
cigpIEZST00KPiAoVkFMVUVTKDMpLCgyKSwoNiksKDEpLCg0KSkgQVMKPiBEST4gaWQodmFsKSkg
QVMgaWQKPiBEST4gT04gKGZvby5jYXRhbG9nX2lkID0gaWQudmFsKSBPUkRFUiBCWSByb3dfbnVt
YmVyOwo+IERJPiBjYXRhbG9nX2lkCj4gREk+IC0tLS0tLS0tLS0tLQo+IERJPiAzCj4gREk+IDIK
PiBEST4gNgo+IERJPiAxCj4gREk+IDQKPgo+Cj4g0LrRgdGC0LDRgtC4IHVubmVzdCDQutCw0Lot
0YLQviDQtNCw0LbQtSDQv9C+0LrQvtGA0L7Rh9C1INCy0YvQs9C70Y/QtNC40YIKPgo+IFNFTEVD
VAo+ICAgIGZvby4qCj4KPiBGUk9NCj4gICAgdW5uZXN0KCd7MywyLDYsMSw0fSc6OmludFtdKSBp
ZHQKPgo+IEpPSU4KPiAgICBmb28gT04gY2F0YWxvZ19pZCA9IGlkdAo+Cj4gV0hFUkUKPiAgICBm
b28uaWQgSVMgTk9UIE5VTEw7Cj4KPiDQuCDQvtGCINGB0L7RgNGC0LjRgNC+0LLQutC4INC80L7Q
ttC90L4g0LjQt9Cx0LDQstC40YLRjNGB0Y8KPgrQmiDRgdC+0LbQsNC70LXQvdC40Y4sINC90LjQ
s9C00LUg0L3QtSDRgdC60LDQt9Cw0L3Qviwg0YfRgtC+IHVubmVzdCgpINC+0LHRj9C30LDQvQrQ
stC10YDQvdGD0YLRjCDQvdCw0LHQvtGAINGN0LvQtdC80LXQvdGC0L7Qsiwg0YHQvtGF0YDQsNC9
0Y/RjyDRg9C/0L7RgNGP0LTQvtGH0LXQvdC90L7RgdGC0YwsCtC30LDQtNCw0L3QvdGD0Y4g0LIg
0LzQsNGB0YHQuNCy0LUuINCf0YDQtdC00L/QvtC70LDQs9Cw0YLRjCDQuCDRgNCw0YHQv9C+0LvQ
sNCz0LDRgtGMIC0K0YHRg9GC0Ywg0YDQsNC30L3Ri9C1INC/0L7QtNGF0L7QtNGLIDotKQrQmtGA
0L7QvNC1INGC0L7Qs9C+LCDQvNC+0LbQtdGCINCy0L7Qt9C90LjQutC90YPRgtGMINC30LDQtNCw
0YfQsCDQstGL0LHRgNCw0YLRjCDRjdC70LXQvNC10L3RgtGLCtCyINC+0LHRgNCw0YLQvdC+0Lwg
0L/QvtGA0Y/QtNC60LUuCgo+Cj4g0YXQvtGC0Y8g0LzQvtC20LXRgiDQvtC/0YLQuNC80LjQt9Cw
0YLQvtGAINC10LUg0Lgg0YHQsNC8INCy0YvQsdGA0L7RgdC40YIuCj4KPiBEST4g0JIg0Y3RgtC+
0Lwg0L/RgNC40LzQtdGA0LUgZm9vIC0g0LjRgdGF0L7QtNC90LDRjyDRgtCw0LHQu9C40YbQsCDR
gSDQtNCw0L3QvdGL0LzQuCwKPiBEST4gaWQgLSDQv9GB0LXQstC00L7RgtCw0LHQu9C40YbQsCDR
gSAyLdC80Y8g0YHRgtC+0LvQsdGG0LDQvNC4OiDQt9C90LDRh9C10L3QuNC1ICjRgdC+0LHRgdGC
0LLQtdC90L3QviBpZCkKPiBEST4g0Lgg0LXQs9C+INC/0L7RgNGP0LTQutC+0LLRi9C5INC90L7Q
vNC10YAuCj4gLS0KPgo+IC4gJydgLiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBEbWl0
cnkgRS4gT2JvdWtob3YKPiA6IDrigJkgIDogICBlbWFpbDogdW5lcmFAZGViaWFuLm9yZyBqYWJi
ZXI6Ly9VTmVyYUB1dncucnUKPiBgLiBgfuKAmSAgICAgICAgICAgICAgR1BHS2V5OiAxMDI0RCAv
IEY4RTI2NTM3IDIwMDYtMTEtMjEKPiAgYC0gMUIyMyBENEY4IDhFQzAgRDkwMiAwNTU1ICBFNDM4
IEFCOEMgMDBDRiBGOEUyIDY1MzcKPgoKCgotLSAKLy8gRG1pdHJpeS4K
--0016363b8ba8aa419b049e76a44f
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: base64

PGJyPjxicj48ZGl2IGNsYXNzPSJnbWFpbF9xdW90ZSI+MTQg0LzQsNGA0YLQsCAyMDExwqDQsy4g
MjI6MjIg0L/QvtC70YzQt9C+0LLQsNGC0LXQu9GMIERtaXRyeSBFLiBPYm91a2hvdiA8c3BhbiBk
aXI9Imx0ciI+Jmx0OzxhIGhyZWY9Im1haWx0bzp1bmVyYUBkZWJpYW4ub3JnIj51bmVyYUBkZWJp
YW4ub3JnPC9hPiZndDs8L3NwYW4+INC90LDQv9C40YHQsNC7Ojxicj48YmxvY2txdW90ZSBjbGFz
cz0iZ21haWxfcXVvdGUiIHN0eWxlPSJtYXJnaW46IDBwdCAwcHQgMHB0IDAuOGV4OyBib3JkZXIt
bGVmdDogMXB4IHNvbGlkIHJnYigyMDQsIDIwNCwgMjA0KTsgcGFkZGluZy1sZWZ0OiAxZXg7Ij4K
PGJyPgpESSZndDsgMTQg0LzQsNGA0YLQsCAyMDExwqDQsy4gMTc6MjAg0L/QvtC70YzQt9C+0LLQ
sNGC0LXQu9GMINCe0LvQtdC60YEg0Lkg0JLQsNGB0LjQu9GMINCyICZsdDs8YSBocmVmPSJtYWls
dG86bGVvcGFyZF9uZUBpbmJveC5ydSI+bGVvcGFyZF9uZUBpbmJveC5ydTwvYT4mZ3Q7PGJyPgpE
SSZndDsg0L3QsNC/0LjRgdCw0Ls6PGJyPgo8YnI+CkRJJmd0OyDQldGB0YLRjCDRgtCw0LrQvtC5
INC30LDQv9GA0L7RgTo8YnI+CkRJJmd0OyBTZWxlY3QgKiBmcm9tIGZvbyB3aGVyZSBjYXRhbG9n
X2lkIElOKDIsMyw2LDEsNCw2Niw0NCwyMyw0NSk8YnI+Cjxicj4KREkmZ3Q7INCS0L7Qt9C80L7Q
ttC90L4g0LvQuCDQstGL0LLQtdGB0YLQuCDRgNC10LfRg9C70YzRgtCw0YIg0LIg0YLQsNC60L7Q
vCDQttC1INC/0L7RgNGP0LTQutC1LCDQutCw0Log0Lgg0YPRgdC70L7QstC40LUg0LIgSU4sPGJy
PgpESSZndDsg0YLQvtC10YHRgtGMINC/0LXRgNCy0YvQuSDQtdC70LXQvNC10L3RgiDRgcKgwqBj
YXRhbG9nX2lkID09IDIsINCy0YLQvtGA0L7QuSAtwqBjYXRhbG9nX2lkID09IDMsINGC0YDQtdGC
0LjQuTxicj4KREkmZ3Q7IC3CoGNhdGFsb2dfaWQgPT0gNiwg0YfQtdGC0LLQtdGA0YLRi9C5IC3C
oGNhdGFsb2dfaWQgPT0gMSDQuCDRgi7QtC48YnI+Cjxicj4KREkmZ3Q7INCU0LDQvdC90YPRjiDQ
t9Cw0LTQsNGH0YMg0LzQvtC20L3QviDRgNC10YjQuNGC0YwsINC30LDQvNC10L3QuNCyIElOINC9
0LAgSk9JTiwg0L3QsNC/0YDQuNC80LXRgDo8YnI+Cjxicj4KREkmZ3Q7IGRtaXRpZ3I9Jmd0Ozxi
cj4KREkmZ3Q7IFNFTEVDVCBmb28uKiBGUk9NIChWQUxVRVMoMSksKDIpLCgzKSwoNCksKDYpKSBB
UyBmb28oY2F0YWxvZ19pZCk8YnI+CkRJJmd0OyBKT0lOIChTRUxFQ1QgaWQudmFsLCByb3dfbnVt
YmVyKCkgb3ZlcigpIEZST00gKFZBTFVFUygzKSwoMiksKDYpLCgxKSwoNCkpIEFTPGJyPgpESSZn
dDsgaWQodmFsKSkgQVMgaWQ8YnI+CkRJJmd0OyBPTiAoZm9vLmNhdGFsb2dfaWQgPSBpZC52YWwp
IE9SREVSIEJZIHJvd19udW1iZXI7PGJyPgpESSZndDsgY2F0YWxvZ19pZDxicj4KREkmZ3Q7IC0t
LS0tLS0tLS0tLTxicj4KREkmZ3Q7IDM8YnI+CkRJJmd0OyAyPGJyPgpESSZndDsgNjxicj4KREkm
Z3Q7IDE8YnI+CkRJJmd0OyA0PGJyPgo8YnI+Cjxicj4K0LrRgdGC0LDRgtC4IHVubmVzdCDQutCw
0Lot0YLQviDQtNCw0LbQtSDQv9C+0LrQvtGA0L7Rh9C1INCy0YvQs9C70Y/QtNC40YI8YnI+Cjxi
cj4KU0VMRUNUPGJyPgogwqAgwqBmb28uKjxicj4KPGJyPgpGUk9NPGJyPgogwqAgwqB1bm5lc3Qo
JiMzOTt7MywyLDYsMSw0fSYjMzk7OjppbnRbXSkgaWR0PGJyPgo8YnI+CkpPSU48YnI+CiDCoCDC
oGZvbyBPTiBjYXRhbG9nX2lkID0gaWR0PGJyPgo8YnI+CldIRVJFPGJyPgogwqAgwqA8YSBocmVm
PSJodHRwOi8vZm9vLmlkIiB0YXJnZXQ9Il9ibGFuayI+Zm9vLmlkPC9hPiBJUyBOT1QgTlVMTDs8
YnI+Cjxicj4K0Lgg0L7RgiDRgdC+0YDRgtC40YDQvtCy0LrQuCDQvNC+0LbQvdC+INC40LfQsdCw
0LLQuNGC0YzRgdGPPGJyPjwvYmxvY2txdW90ZT48ZGl2PtCaINGB0L7QttCw0LvQtdC90LjRjiwg
0L3QuNCz0LTQtSDQvdC1INGB0LrQsNC30LDQvdC+LCDRh9GC0L4gdW5uZXN0KCkg0L7QsdGP0LfQ
sNC9PGJyPtCy0LXRgNC90YPRgtGMINC90LDQsdC+0YAg0Y3Qu9C10LzQtdC90YLQvtCyLCDRgdC+
0YXRgNCw0L3Rj9GPINGD0L/QvtGA0Y/QtNC+0YfQtdC90L3QvtGB0YLRjCw8YnI+0LfQsNC00LDQ
vdC90YPRjiDQsiDQvNCw0YHRgdC40LLQtS4g0J/RgNC10LTQv9C+0LvQsNCz0LDRgtGMINC4INGA
0LDRgdC/0L7Qu9Cw0LPQsNGC0YwgLTxicj7RgdGD0YLRjCDRgNCw0LfQvdGL0LUg0L/QvtC00YXQ
vtC00YsgOi0pPGJyPgrQmtGA0L7QvNC1INGC0L7Qs9C+LCDQvNC+0LbQtdGCINCy0L7Qt9C90LjQ
utC90YPRgtGMINC30LDQtNCw0YfQsCDQstGL0LHRgNCw0YLRjCDRjdC70LXQvNC10L3RgtGLPGJy
PtCyINC+0LHRgNCw0YLQvdC+0Lwg0L/QvtGA0Y/QtNC60LUuPGJyPjwvZGl2PjxibG9ja3F1b3Rl
IGNsYXNzPSJnbWFpbF9xdW90ZSIgc3R5bGU9Im1hcmdpbjogMHB0IDBwdCAwcHQgMC44ZXg7IGJv
cmRlci1sZWZ0OiAxcHggc29saWQgcmdiKDIwNCwgMjA0LCAyMDQpOyBwYWRkaW5nLWxlZnQ6IDFl
eDsiPgo8YnI+CtGF0L7RgtGPINC80L7QttC10YIg0L7Qv9GC0LjQvNC40LfQsNGC0L7RgCDQtdC1
INC4INGB0LDQvCDQstGL0LHRgNC+0YHQuNGCLjxicj4KPGJyPgpESSZndDsg0JIg0Y3RgtC+0Lwg
0L/RgNC40LzQtdGA0LUgZm9vIC0g0LjRgdGF0L7QtNC90LDRjyDRgtCw0LHQu9C40YbQsCDRgSDQ
tNCw0L3QvdGL0LzQuCw8YnI+CkRJJmd0OyBpZCAtINC/0YHQtdCy0LTQvtGC0LDQsdC70LjRhtCw
INGBIDIt0LzRjyDRgdGC0L7Qu9Cx0YbQsNC80Lg6INC30L3QsNGH0LXQvdC40LUgKNGB0L7QsdGB
0YLQstC10L3QvdC+IGlkKTxicj4KREkmZ3Q7INC4INC10LPQviDQv9C+0YDRj9C00LrQvtCy0YvQ
uSDQvdC+0LzQtdGALjxicj4KPGRpdj48ZGl2PjwvZGl2PjxkaXYgY2xhc3M9Img1Ij4tLTxicj4K
PGJyPgouICYjMzk7JiMzOTtgLiDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC
oCDCoCDCoCBEbWl0cnkgRS4gT2JvdWtob3Y8YnI+CjogOuKAmSDCoDogwqAgZW1haWw6IDxhIGhy
ZWY9Im1haWx0bzp1bmVyYUBkZWJpYW4ub3JnIj51bmVyYUBkZWJpYW4ub3JnPC9hPiBqYWJiZXI6
Ly88YSBocmVmPSJtYWlsdG86VU5lcmFAdXZ3LnJ1Ij5VTmVyYUB1dncucnU8L2E+PGJyPgpgLiBg
fuKAmSDCoCDCoCDCoCDCoCDCoCDCoCDCoEdQR0tleTogMTAyNEQgLyBGOEUyNjUzNyAyMDA2LTEx
LTIxPGJyPgogwqBgLSAxQjIzIEQ0RjggOEVDMCBEOTAyIDA1NTUgwqBFNDM4IEFCOEMgMDBDRiBG
OEUyIDY1Mzc8YnI+CjwvZGl2PjwvZGl2PjwvYmxvY2txdW90ZT48L2Rpdj48YnI+PGJyIGNsZWFy
PSJhbGwiPjxicj4tLSA8YnI+Ly8gRG1pdHJpeS48YnI+PGJyPjxicj4K
--0016363b8ba8aa419b049e76a44f--



From unera@debian.org Mon Mar  14 21:25:27 2011
Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id DB8FC1337BCC
	for <pgsql-ru-general-postgresql.org@mail.postgresql.org>;
	Mon, 14 Mar 2011 18:25:46 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 60749-03
	for <pgsql-ru-general-postgresql.org@mail.postgresql.org>;
	Mon, 14 Mar 2011 21:25:37 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from vdst.uvw.ru (vdst.uvw.ru [206.123.89.0])
	by mail.postgresql.org (Postfix) with ESMTP id 921FC133616B
	for <pgsql-ru-general@postgresql.org>;
	Mon, 14 Mar 2011 18:25:36 -0300 (ADT)
Received: from [10.255.1.66] (helo=apache.rbscorp.ru)
	by vdst.uvw.ru with esmtp (Exim 4.72) (envelope-from <dimka@uvw.ru>)
	id 1PzFGf-0004Z4-9X; Tue, 15 Mar 2011 00:25:36 +0300
Received: from dimka by apache.rbscorp.ru with local (Exim 4.72)
	(envelope-from <dimka@apache.rbscorp.ru>)
	id 1PzFGZ-0000RA-36; Tue, 15 Mar 2011 00:25:27 +0300
Date: Tue, 15 Mar 2011 00:25:27 +0300
From: "Dmitry E. Oboukhov" <unera@debian.org>
To: Dmitriy Igrishin <dmitigr@gmail.com>
Cc: pgsql-ru-general@postgresql.org
Message-ID: <20110314212526.GI19356@apache.rbscorp.ru>
References: <E1Pz8dD-00012t-00.leopard_ne-inbox-ru@f261.mail.ru>
	<AANLkTi=dhU+g9NWEEpBS_fgWZHLynxXpAtiZTvEUEo=o@mail.gmail.com>
	<20110314191250.GF19356@apache.rbscorp.ru>
	<AANLkTi=VgG7DfCtpTitXneiS0eWrJPBmvOo14Q8ez9Pe@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-ripemd160;
	protocol="application/pgp-signature"; boundary="wtjvnLv0o8UUzur2"
Content-Disposition: inline
In-Reply-To: <AANLkTi=VgG7DfCtpTitXneiS0eWrJPBmvOo14Q8ez9Pe@mail.gmail.com>
User-Agent: Mutt/1.5.21 (2010-09-15)
X-SA-Exim-Connect-IP: 10.255.1.66
X-SA-Exim-Mail-From: dimka@uvw.ru
Subject: Re: Re: =?utf-8?B?W3Bn?=
	=?utf-8?B?c3FsLXJ1LWdlbmVyYWxdIFJlOiBbcGdzcWwtcnUtZ2VuZXJhbF0g0KHQvtGA?=
	=?utf-8?B?0YLQuNGA0L7QstC60LAg0LIg0YLRgNC10LHRg9C10LzQvtC8INC/0L7RgNGP?=
	=?utf-8?B?0LTQutC1?=
X-SA-Exim-Version: 4.2.1 (built Mon, 22 Mar 2010 06:51:10 +0000)
X-SA-Exim-Scanned: No (on vdst.uvw.ru); Unknown failure
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.79 tagged_above=-10 required=5 tests=BAYES_50=0.8,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201103/77
X-Sequence-Number: 1209


--wtjvnLv0o8UUzur2
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

DI> =D0=9A =D1=81=D0=BE=D0=B6=D0=B0=D0=BB=D0=B5=D0=BD=D0=B8=D1=8E, =D0=BD=
=D0=B8=D0=B3=D0=B4=D0=B5 =D0=BD=D0=B5 =D1=81=D0=BA=D0=B0=D0=B7=D0=B0=D0=BD=
=D0=BE, =D1=87=D1=82=D0=BE unnest() =D0=BE=D0=B1=D1=8F=D0=B7=D0=B0=D0=BD
DI> =D0=B2=D0=B5=D1=80=D0=BD=D1=83=D1=82=D1=8C =D0=BD=D0=B0=D0=B1=D0=BE=D1=
=80 =D1=8D=D0=BB=D0=B5=D0=BC=D0=B5=D0=BD=D1=82=D0=BE=D0=B2, =D1=81=D0=BE=D1=
=85=D1=80=D0=B0=D0=BD=D1=8F=D1=8F =D1=83=D0=BF=D0=BE=D1=80=D1=8F=D0=B4=D0=
=BE=D1=87=D0=B5=D0=BD=D0=BD=D0=BE=D1=81=D1=82=D1=8C,
DI> =D0=B7=D0=B0=D0=B4=D0=B0=D0=BD=D0=BD=D1=83=D1=8E =D0=B2 =D0=BC=D0=B0=D1=
=81=D1=81=D0=B8=D0=B2=D0=B5. =D0=9F=D1=80=D0=B5=D0=B4=D0=BF=D0=BE=D0=BB=D0=
=B0=D0=B3=D0=B0=D1=82=D1=8C =D0=B8 =D1=80=D0=B0=D1=81=D0=BF=D0=BE=D0=BB=D0=
=B0=D0=B3=D0=B0=D1=82=D1=8C -
DI> =D1=81=D1=83=D1=82=D1=8C =D1=80=D0=B0=D0=B7=D0=BD=D1=8B=D0=B5 =D0=BF=D0=
=BE=D0=B4=D1=85=D0=BE=D0=B4=D1=8B :-)

=D0=92=D0=B5=D1=80=D0=BE=D1=8F=D1=82=D0=BD=D0=BE =D0=92=D1=8B =D0=BF=D1=80=
=D0=B0=D0=B2=D1=8B, =D0=BE=D0=B4=D0=BD=D0=B0=D0=BA=D0=BE =D0=BC=D0=BD=D0=B5=
 =D0=BA=D1=80=D0=B0=D0=B9=D0=BD=D0=B5 =D1=81=D0=BB=D0=BE=D0=B6=D0=BD=D0=BE =
=D0=BF=D1=80=D0=B5=D0=B4=D1=81=D1=82=D0=B0=D0=B2=D0=B8=D1=82=D1=8C =D1=81=
=D0=B5=D0=B1=D0=B5
=D1=80=D0=B5=D0=B0=D0=BB=D0=B8=D0=B7=D0=B0=D1=86=D0=B8=D1=8E =D1=84=D1=83=
=D0=BD=D0=BA=D1=86=D0=B8=D0=B8 =D0=BF=D1=80=D0=B5=D0=BE=D0=B1=D1=80=D0=B0=
=D0=B7=D0=BE=D0=B2=D0=B0=D0=BD=D0=B8=D1=8F =D0=BC=D0=B0=D1=82=D1=80=D0=B8=
=D1=86=D1=8B =D0=B2=D0=B8=D0=B4=D0=B0=20
[ 1 2 3 ]
=D0=B2 =D0=BC=D0=B0=D1=82=D1=80=D0=B8=D1=86=D1=83 =D0=B2=D0=B8=D0=B4=D0=B0
[
  1
  2
  3
]

=D1=87=D1=82=D0=BE=D0=B1=D1=8B =D0=BF=D1=80=D0=B8 =D1=8D=D1=82=D0=BE=D0=BC =
=D0=BC=D0=BE=D0=B3 =D0=BF=D0=BE=D1=81=D1=82=D1=80=D0=B0=D0=B4=D0=B0=D1=82=
=D1=8C =D0=BF=D0=BE=D1=80=D1=8F=D0=B4=D0=BE=D0=BA =D1=81=D0=BB=D0=B5=D0=B4=
=D0=BE=D0=B2=D0=B0=D0=BD=D0=B8=D1=8F. =D1=8D=D1=82=D0=BE =D1=80=D0=B0=D0=B7=
=D0=B2=D0=B5 =D1=87=D1=82=D0=BE
=D1=81=D0=BF=D0=B5=D1=86=D0=B8=D0=B0=D0=BB=D1=8C=D0=BD=D0=BE =D1=87=D1=82=
=D0=BE-=D1=82=D0=BE =D0=B4=D0=B5=D0=BB=D0=B0=D1=82=D1=8C =D0=BD=D0=B0=D0=B4=
=D0=BE?

DI> =D0=9A=D1=80=D0=BE=D0=BC=D0=B5 =D1=82=D0=BE=D0=B3=D0=BE, =D0=BC=D0=BE=
=D0=B6=D0=B5=D1=82 =D0=B2=D0=BE=D0=B7=D0=BD=D0=B8=D0=BA=D0=BD=D1=83=D1=82=
=D1=8C =D0=B7=D0=B0=D0=B4=D0=B0=D1=87=D0=B0 =D0=B2=D1=8B=D0=B1=D1=80=D0=B0=
=D1=82=D1=8C =D1=8D=D0=BB=D0=B5=D0=BC=D0=B5=D0=BD=D1=82=D1=8B
DI> =D0=B2 =D0=BE=D0=B1=D1=80=D0=B0=D1=82=D0=BD=D0=BE=D0=BC =D0=BF=D0=BE=D1=
=80=D1=8F=D0=B4=D0=BA=D0=B5.

=D0=BD=D0=B0=D1=81=D0=BA=D0=BE=D0=BB=D1=8C=D0=BA=D0=BE =D1=8F =D0=BF=D0=BE=
=D0=BD=D0=B8=D0=BC=D0=B0=D1=8E =D0=B8=D0=BC=D0=B5=D1=8E=D1=89=D1=83=D1=8E=
=D1=81=D1=8F =D0=B7=D0=B0=D0=B4=D0=B0=D1=87=D1=83 - =D0=BF=D0=BE=D1=80=D1=
=8F=D0=B4=D0=BE=D0=BA =D0=BF=D1=80=D0=B8=D1=85=D0=BE=D0=B4=D0=B8=D1=82 =D0=
=BA=D0=B0=D0=BA =D1=80=D0=B5=D0=B7=D1=83=D0=BB=D1=8C=D1=82=D0=B0=D1=82
=D1=80=D0=B0=D0=B1=D0=BE=D1=82=D1=8B =D1=87=D0=B5=D0=B3=D0=BE-=D1=82=D0=BE =
=D1=82=D0=B0=D0=BC (=D1=8E=D0=B7=D0=B5=D1=80=D1=81=D0=BA=D0=B8=D1=85 =D0=B2=
=D1=8B=D0=B1=D0=BE=D1=80=D0=BE=D0=BA =D0=BD=D0=B0=D0=BF=D1=80=D0=B8=D0=BC=
=D0=B5=D1=80) =D0=B8, =D0=B2=D0=B5=D1=80=D0=BE=D1=8F=D1=82=D0=BD=D0=BE, =D0=
=B2 =D1=8D=D1=82=D0=BE=D0=BC
=D1=81=D0=BB=D1=83=D1=87=D0=B0=D0=B5 =D0=BF=D1=80=D0=B8=D0=B4=D0=B5=D1=82 =
=D0=BE=D0=B1=D1=80=D0=B0=D1=82=D0=BD=D1=8B=D0=B9 =D0=B6=D0=B5 =D0=BF=D0=BE=
=D1=80=D1=8F=D0=B4=D0=BE=D0=BA =D0=BD=D0=B0 =D0=B2=D1=85=D0=BE=D0=B4 =D0=BF=
=D1=80=D0=BE=D1=81=D1=82=D0=BE

--=20

=2E ''`.                               Dmitry E. Oboukhov
: :=E2=80=99  :   email: unera@debian.org jabber://UNera@uvw.ru
`. `~=E2=80=99              GPGKey: 1024D / F8E26537 2006-11-21
  `- 1B23 D4F8 8EC0 D902 0555  E438 AB8C 00CF F8E2 6537

--wtjvnLv0o8UUzur2
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iEYEAREDAAYFAk1+h8YACgkQq4wAz/jiZTdYQACfbY2uAl9KSyPoMb9XNmVCOuyn
BegAoO3Sn8wLC+Df1hTj27yAsH/7LHA1
=HnXZ
-----END PGP SIGNATURE-----

--wtjvnLv0o8UUzur2--



From mboguk@masterhost.ru Tue Mar  15 08:11:53 2011
Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id B9A981337BF0
	for <pgsql-ru-general-postgresql.org@mail.postgresql.org>;
	Tue, 15 Mar 2011 05:18:51 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 77553-05
	for <pgsql-ru-general-postgresql.org@mail.postgresql.org>;
	Tue, 15 Mar 2011 08:18:44 +0000 (UTC)
X-Greylist: delayed 00:06:40.065238 by SQLgrey-1.7.6
Received: from csmtp-2.masterhost.ru (csmtp1.masterhost.ru [83.222.22.203])
	by mail.postgresql.org (Postfix) with SMTP id 4C0E81337B58
	for <pgsql-ru-general@postgresql.org>;
	Tue, 15 Mar 2011 05:18:43 -0300 (ADT)
Received: (qmail 59568 invoked from network); 15 Mar 2011 08:12:00 -0000
Received: from unknown (HELO ?192.168.1.65?)
	(mboguk@masterhost.ru@121.98.213.188)
	by csmtp1.masterhost.ru with SMTP; 15 Mar 2011 08:12:00 -0000
Message-ID: <4D7F1F49.4040809@masterhost.ru>
Date: Tue, 15 Mar 2011 21:11:53 +1300
From: Maxim Boguk <mboguk@masterhost.ru>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US;
	rv:1.9.2.15) Gecko/20110303 Thunderbird/3.1.9
MIME-Version: 1.0
To: pgsql-ru-general@postgresql.org
Subject: =?KOI8-R?Q?Re=3A_=5Bpgsql-ru-general=5D_Re=3A_=5Bpgsql-ru-?=
	=?KOI8-R?Q?general=5D_=F3=CF=D2=D4=C9=D2=CF=D7=CB=C1_=D7_=D4=D2=C5?=
	=?KOI8-R?Q?=C2=D5=C5=CD=CF=CD_=D0=CF=D2=D1=C4=CB=C5?=
References: <E1Pz8dD-00012t-00.leopard_ne-inbox-ru@f261.mail.ru>
	<AANLkTi=dhU+g9NWEEpBS_fgWZHLynxXpAtiZTvEUEo=o@mail.gmail.com>
	<20110314191250.GF19356@apache.rbscorp.ru>
In-Reply-To: <20110314191250.GF19356@apache.rbscorp.ru>
Content-Type: text/plain; charset=KOI8-R; format=flowed
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=3.062 tagged_above=-10 required=5 tests=BAYES_50=0.8,
	FSL_RU_URL=2.271, RFC_ABUSE_POST=0.001, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: ***
X-Archive-Number: 201103/78
X-Sequence-Number: 1210

On 15/03/11 08:22, Dmitry E. Oboukhov wrote:
>
> DI>  14 марта 2011 г. 17:20 пользователь Олекс й Василь в<leopard_ne@inbox.ru>
> DI>  написал:
>
> DI>  Есть такой запрос:
> DI>  Select * from foo where catalog_id IN(2,3,6,1,4,66,44,23,45)
>
> DI>  Возможно ли вывести результат в таком же порядке, как и условие в IN,
> DI>  тоесть первый елемент с  catalog_id == 2, второй - catalog_id == 3, третий
> DI>  - catalog_id == 6, четвертый - catalog_id == 1 и т.д.
>
> DI>  Данную задачу можно решить, заменив IN на JOIN, например:
>
> DI>  dmitigr=>
> DI>  SELECT foo.* FROM (VALUES(1),(2),(3),(4),(6)) AS foo(catalog_id)
> DI>  JOIN (SELECT id.val, row_number() over() FROM (VALUES(3),(2),(6),(1),(4)) AS
> DI>  id(val)) AS id
> DI>  ON (foo.catalog_id = id.val) ORDER BY row_number;
> DI>  catalog_id
> DI>  ------------
> DI>  3
> DI>  2
> DI>  6
> DI>  1
> DI>  4
>
>
> кстати unnest как-то даже покороче выглядит
>
> SELECT
>      foo.*
>
> FROM
>      unnest('{3,2,6,1,4}'::int[]) idt
>
> JOIN
>      foo ON catalog_id = idt
>

Если оптимизатор выберет hashjoin или mergejoin вместо nested loop
то порядок результатов в выдаче будет произволен. Лучше не использовать 
такой подход.

PS: никакой запрос без order by не дает гарантированной сортировки. все 
ухищрения чтобы без этого обойтись или работают не всегда или могут 
перестать работать даже при смене минорной версии базы.

-- 
SY, Maxim Boguk