Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VQg5F-0002C8-G9 for pgsql-es-ayuda@arkaria.postgresql.org; Mon, 30 Sep 2013 16:12:29 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VQg5E-0000Yr-SW for pgsql-es-ayuda@arkaria.postgresql.org; Mon, 30 Sep 2013 16:12:28 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VQg5E-0000Yk-5q for pgsql-es-ayuda@postgresql.org; Mon, 30 Sep 2013 16:12:28 +0000 Received: from smtprelay0023.b.hostedemail.com ([64.98.42.23] helo=smtprelay.b.hostedemail.com) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VQg5B-00045T-42 for pgsql-es-ayuda@postgresql.org; Mon, 30 Sep 2013 16:12:27 +0000 Received: from filter.hostedemail.com (b-bigip1 [10.5.19.254]) by smtprelay03.b.hostedemail.com (Postfix) with ESMTP id 80E8B1A730D; Mon, 30 Sep 2013 16:12:24 +0000 (UTC) X-Session-Marker: 616C76686572726540616C76682E6E6F2D69702E6F7267 X-Spam-Summary: 50, 3, 0, , d41d8cd98f00b204, alvherre@alvh.no-ip.org, :::, RULES_HIT:41:46:150:153:355:379:599:967:973:988:989:1260:1277:1311:1312:1313:1314:1345:1359:1437:1515:1516:1518:1519:1534:1540:1593:1594:1595:1596:1711:1730:1747:1777:1792:2393:2525:2560:2563:2682:2685:2828:2859:2933:2937:2939:2942:2945:2947:2951:2954:3022:3138:3139:3140:3141:3142:3352:3868:3870:3934:3936:3938:3941:3944:3947:3950:3953:3956:3959:4250:4605:4659:5007:6261:7904:8784:9025:9121:10004:10400:10848:11026:11256:11257:11639:11658:11914:12043:12438:12517:12519:13069:13311:13357:13894:13895, 0, RBL:none, CacheIP:none, Bayesian:0.5, 0.5, 0.5, Netcheck:none, DomainCache:0, MSF:not bulk, SPF:fn, MSBL:0, DNSBL:none, Custom_rules:0:0:0 X-HE-Tag: game48_4ed9b9ae24f2a X-Filterd-Recvd-Size: 1874 Received: from eldon.alvh.no-ip.org (unknown [200.126.66.202]) (Authenticated sender: alvherre@alvh.no-ip.org) by omf01.b.hostedemail.com (Postfix) with ESMTPA; Mon, 30 Sep 2013 16:12:21 +0000 (UTC) Received: by eldon.alvh.no-ip.org (Postfix, from userid 1000) id 43D4A1FC8; Mon, 30 Sep 2013 13:12:20 -0300 (CLST) Date: Mon, 30 Sep 2013 13:12:20 -0300 From: Alvaro Herrera To: Carlos Eduardo Sotelo Pinto Cc: pgsql-es-ayuda@postgresql.org Subject: Re: Fwd: Help =?utf-8?Q?o?= =?utf-8?B?biDhuZVlcmZvcm1hbmNl?= Message-ID: <20130930161220.GD5235@eldon.alvh.no-ip.org> References: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.5.21 (2010-09-15) X-Pg-Spam-Score: 0.8 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-es-ayuda Precedence: bulk Sender: pgsql-es-ayuda-owner@postgresql.org Carlos Eduardo Sotelo Pinto escribió: > DECLARE > arr varchar[]; > BEGIN > arr := regexp_split_to_array(_imeis, E'\\s+'); > FOR i IN 1..array_length(arr, 1) LOOP > RETURN QUERY Creo que deberías hacer una única consulta con todos los elementos del array, en lugar de una consulta para cada elemento. Es decir, elimina el LOOP y el LIMIT 1, y tu WHERE debería ser algo como ... > FROM gpstracking_device_tracks > WHERE gpstracking_device_tracks.imei = arr[i]::VARCHAR WHERE gpstracking_device_tracks.imei = ANY (arr) AND ... Vas a tener que solucionar de otra forma el que te retorne sólo una fila para cada imei, claro. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services - Enviado a la lista de correo pgsql-es-ayuda (pgsql-es-ayuda@postgresql.org) Para cambiar tu suscripción: http://www.postgresql.org/mailpref/pgsql-es-ayuda