Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id D93091337B93 for ; Wed, 9 Mar 2011 16:18:39 -0400 (AST) 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 94818-03 for ; Wed, 9 Mar 2011 20:18:32 +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 318551337B82 for ; Wed, 9 Mar 2011 16:18:32 -0400 (AST) Received: from [10.255.1.66] (helo=apache.rbscorp.ru) by vdst.uvw.ru with esmtp (Exim 4.72) (envelope-from ) id 1PxPq0-0005mF-Id for pgsql-ru-general@postgresql.org; Wed, 09 Mar 2011 23:18:31 +0300 Received: from dimka by apache.rbscorp.ru with local (Exim 4.72) (envelope-from ) id 1PxPpy-0005bX-D4 for pgsql-ru-general@postgresql.org; Wed, 09 Mar 2011 23:18:26 +0300 Date: Wed, 9 Mar 2011 23:18:26 +0300 From: "Dmitry E. Oboukhov" To: pgsql-ru-general@postgresql.org Message-ID: <20110309201825.GA20505@apache.rbscorp.ru> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-ripemd160; protocol="application/pgp-signature"; boundary="5vNYLRcllDrimb99" Content-Disposition: inline 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: hstore & plperl & =?utf-8?B?0LzQsNGB0YE=?= =?utf-8?B?0LjQstGL?= 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/39 X-Sequence-Number: 1171 --5vNYLRcllDrimb99 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable =D1=85=D0=BE=D1=87=D1=83 =D1=81=D0=BA=D0=B0=D0=B7=D0=B0=D1=82=D1=8C =D1=81= =D0=BF=D0=B0=D1=81=D0=B8=D0=B1=D0=BE =D0=B7=D0=B0 =D1=81=D0=BE=D0=B2=D0=B5= =D1=82 =D0=BF=D0=BE=D1=81=D0=BC=D0=BE=D1=82=D1=80=D0=B5=D1=82=D1=8C =D0=BD= =D0=B0 hstore, =D1=81=D0=B5=D0=B9=D1=87=D0=B0=D1=81 =D0=BD=D0=B5=D0=BC=D0= =BD=D0=BE=D0=B3=D0=BE =D0=BF=D0=B5=D1=80=D0=B5=D0=B4=D0=B5=D0=BB=D0=B0=D0=BB =D1=82=D0=B5=D1=81= =D1=82=D0=BE=D0=B2=D1=83=D1=8E =D0=91=D0=94 =D0=BF=D0=BE=D0=BB=D1=83=D1=87= =D0=B0=D0=B5=D1=82=D1=81=D1=8F =D0=BE=D1=87=D0=B5=D0=BD=D1=8C =D0=BA=D1=80= =D0=B0=D1=81=D0=B8=D0=B2=D0=BE =D1=81 hstore. =D0=BE=D0=B4=D0=BD=D0=B0=D0=BA=D0=BE =D1=85=D0=BE=D1=87=D0=B5=D1=82=D1=81= =D1=8F =D1=81 =D0=BD=D0=B8=D0=BC=D0=B8 =D0=BF=D0=BE=D1=80=D0=B0=D0=B1=D0=BE= =D1=82=D0=B0=D1=82=D1=8C =D0=B8=D0=B7 =D1=85=D1=80=D0=B0=D0=BD=D0=B8=D0=BC= =D0=BA=D0=B8 =D0=BD=D0=B0 plperl, =D0=B2=D0=BE=D0=BF=D1=80=D0=BE=D1=81: =D1= =8D=D1=82=D0=BE =D0=BD=D0=B0=D0=B4=D0=BE =D0=BF=D0=BE=D0=BB=D1=83=D1=87=D0=B0=D0=B5=D1=82= =D1=81=D1=8F =D0=B5=D0=B5 =D1=80=D0=B0=D1=81=D0=BF=D0=B0=D1=80=D1=81=D0=B8= =D0=B2=D0=B0=D1=82=D1=8C =D0=B2=D1=80=D1=83=D1=87=D0=BD=D1=83=D1=8E =D0=B8= =D0=BB=D0=B8 =D0=B5=D1=81=D1=82=D1=8C =D0=B3=D0=BE=D1=82=D0=BE=D0=B2=D1=8B= =D0=B5 =D0=BB=D0=B8=D0=B1=D1=8B =D0=BD=D0=B0 =D1=8D=D1=82=D1=83 =D1=82=D0=B5=D0=BC=D1=83? =D0=B8 =D0=B5=D1=89=D0=B5 =D0=B2=D0=BE=D0=BF=D1=80=D0=BE=D1=81 =D0=BF=D0=BE= =D0=BC=D0=B0=D1=81=D1=81=D0=B8=D0=B2=D0=B0=D0=BC: =D0=B5=D1=81=D1=82=D1=8C =D1=81=D1=82=D0=BE=D0=BB=D0=B1=D0=B8=D0=BA: val hstore[] =D1=85=D0=BE=D1=82=D0=B8=D0=BC =D0=B4=D0=BE=D0=B1=D0=B0=D0=B2=D0=BB=D1=8F= =D1=82=D1=8C =D0=B2 =D0=BD=D0=B5=D0=B3=D0=BE =D1=82=D0=BE=D1=87=D0=BA=D0=B8 array_append("val", "point") - =D0=B4=D0=BE=D0=B1=D0=B0=D0=B2=D0=BB=D1=8F= =D0=B5=D1=82, =D0=BD=D0=BE =D0=BF=D0=BE=D1=81=D0=BA=D0=BE=D0=BB=D1=8C=D0=BA= =D1=83 =D1=82=D0=BE=D1=87=D0=BA=D0=B8 =D0=BF=D1=80=D0=B8=D1=85=D0=BE=D0=B4= =D1=8F=D1=82 =D0=BD=D0=B5=D1=83=D0=BF=D0=BE=D1=80=D1=8F=D0=B4=D0=BE=D1=87=D0=B5=D0=BD= =D0=BE, =D1=82=D0=BE =D1=85=D0=BE=D1=87=D0=B5=D1=82=D1=81=D1=8F =D1=82=D1= =83=D1=82 =D0=B2=D0=BA=D1=80=D1=8F=D1=87=D0=B8=D1=82=D1=8C=D1=81=D1=8F =D1= =81=D0=BE =D1=81=D0=B2=D0=BE=D0=B5=D0=B9 =D0=BF=D1=80=D0=BE=D1=86=D0=B5=D0= =B4=D1=83=D1=80=D0=BA=D0=BE=D0=B9 =D0=BA=D0=BE=D1=82=D0=BE=D1=80=D0=B0=D1=8F =D0=BF=D1=80=D0=B8 =D0=B2=D1=81=D1=82=D0=B0=D0=B2=D0=BA=D0=B5 =D0=B4=D0=B5= =D0=BB=D0=B0=D0=BB=D0=B0 =D0=B1=D1=8B =D1=83=D0=BF=D0=BE=D1=80=D1=8F=D0=B4= =D0=BE=D1=87=D0=B8=D0=B2=D0=B0=D0=BD=D0=B8=D0=B5. =D1=81=D0=BE=D0=BE=D1=82=D0=B2=D0=B5=D1=82=D1=81=D1=82=D0=B2=D0=B5=D0=BD= =D0=BD=D0=BE =D0=B1=D0=B8=D0=BD=D0=B0=D1=80=D0=BD=D1=8B=D0=B9 =D0=BF=D0=BE= =D0=B8=D1=81=D0=BA/=D1=81=D0=BE=D1=80=D1=82=D0=B8=D1=80=D0=BE=D0=B2=D0=BA= =D0=B0 =D0=BD=D1=83=D0=B6=D0=BD=D1=8B. =D0=BC=D0=BE=D0=B6=D0=BD=D0=BE =D0= =BA=D0=BE=D0=BD=D0=B5=D1=87=D0=BD=D0=BE =D0=BD=D0=B0=D0=BF=D0=B8=D1=81=D0=B0=D1=82=D1=8C =D1=81=D0=B0=D0=BC=D0=BE= =D0=BC=D1=83, =D0=BD=D0=BE =D0=BC=D0=BE=D0=B6=D0=B5=D1=82 =D0=B1=D1=8B=D1= =82=D1=8C =D0=BE=D0=BF=D1=8F=D1=82=D1=8C =D1=87=D1=82=D0=BE-=D1=82=D0=BE = =D0=B5=D1=81=D1=82=D1=8C =D0=B3=D0=BE=D1=82=D0=BE=D0=B2=D0=BE=D0=B5 =D0=BD= =D0=B0 =D1=8D=D1=82=D1=83 =D1=82=D0=B5=D0=BC=D1=83? =D0=BC=D0=BE=D0=B6=D0=BD=D0=BE =D1=81=D0=B4=D0=B5=D0=BB=D0=B0=D1=82=D1=8C = =D0=B5=D1=89=D0=B5 ARRAY_AGG(SELECT UNNEST(val || ARRAY["point"]::hstore[]) t ORDER BY t->'ke= y') =D0=BD=D0=BE =D1=8D=D1=82=D0=BE =D0=B1=D1=83=D0=B4=D0=B5=D1=82 =D1=81=D0= =BE=D1=80=D1=82=D0=B8=D1=80=D0=BE=D0=B2=D0=BA=D0=B0 =D0=BD=D0=B0 =D0=BA=D0= =B0=D0=B6=D0=B4=D0=BE=D0=BC =D0=B4=D0=BE=D0=B1=D0=B0=D0=B2=D0=BB=D0=B5=D0= =BD=D0=B8=D0=B8 =D1=82=D0=BE=D1=87=D0=BA=D0=B8 --=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 --5vNYLRcllDrimb99 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) iEYEAREDAAYFAk134JEACgkQq4wAz/jiZTf28ACdF8upAntEeVBlJ0hmZP2vxY6X JksAn3d0mH34rR6dZgAHrc41JBHU35dC =/ERg -----END PGP SIGNATURE----- --5vNYLRcllDrimb99--