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)
Subject: Re: Re: =?utf-8?B?W3Bn?=
	=?utf-8?B?c3FsLXJ1LWdlbmVyYWxdINCh0L7RgNGC0LjRgNC+0LLQutCwINCyINGC0YA=?=
	=?utf-8?B?0LXQsdGD0LXQvNC+0Lwg0L/QvtGA0Y/QtNC60LU=?=


--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--