Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 3E8D51337BF5 for ; 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 ; 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 ; 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 ) 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 ) 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" To: pgsql-ru-general@postgresql.org Message-ID: <20110314191250.GF19356@apache.rbscorp.ru> References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-ripemd160; protocol="application/pgp-signature"; boundary="+KJYzRxRHjYqLGl5" Content-Disposition: inline In-Reply-To: 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 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--