Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id EBDD3B5DBF0
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu, 26 May 2011 09:49:58 -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 78754-02
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu, 26 May 2011 12:49:50 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from lerner.co.il (unknown [69.55.231.201])
	by mail.postgresql.org (Postfix) with ESMTP id 43D2AB5D95B
	for <pgsql-performance@postgresql.org>;
	Thu, 26 May 2011 09:49:49 -0300 (ADT)
Received: by lerner.co.il (Postfix, from userid 1003)
	id F3F785D7C3B; Thu, 26 May 2011 15:49:47 +0300 (IDT)
X-DKIM: Sendmail DKIM Filter v2.8.3 lerner.co.il F3F785D7C3B
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=lerner.co.il;
	s=MAILOUT; t=1306414188;
	bh=5iJoCRgjwd+GcP0iOvkFwzEJxvWgENAXCGSYHRsEtJ8=;
	h=Message-ID:Date:From:MIME-Version:To:CC:Subject:References:
	In-Reply-To:Content-Type:Content-Transfer-Encoding;
	b=HPjXlYmlzi823TbE9g+22XtddyZ5D39Mqqxj/IF/TjrR3TEnJSrHEusO4t6cPNEy2
	sPZDSlyuMTOZYCbaUG+dd4RzbeX5xC5WVcev7BX3irlcCr4w+HQ/rbbAXTZ1Ga0TOS
	VVKi1HuJw3yeocXvNrJYUZ3nIab4LLZx3X48ByJQ=
Received: from Reuvens-MacBook-Pro.local
	(bzq-84-108-249-150.cablep.bezeqint.net [84.108.249.150])
	by lerner.co.il (Postfix) with ESMTPS id 189F35D7C2E;
	Thu, 26 May 2011 15:49:39 +0300 (IDT)
X-DKIM: Sendmail DKIM Filter v2.8.3 lerner.co.il 189F35D7C2E
Message-ID: <4DDE4C61.4060105@lerner.co.il>
Date: Thu, 26 May 2011 15:49:37 +0300
From: "Reuven M. Lerner" <reuven@lerner.co.il>
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US;
	rv:1.9.2.17) Gecko/20110414 Thunderbird/3.1.10
MIME-Version: 1.0
To: Merlin Moncure <mmoncure@gmail.com>
CC: Steve Crawford <scrawford@pinpointresearch.com>,
	Alex Hunsaker <badalex@gmail.com>, pgsql-performance@postgresql.org
Subject: Re: Speeding up loops in pl/pgsql function
References: <4DDD358E.20307@lerner.co.il>
	<BANLkTinuiR=Txtn_dUeSbvvgcWZj9c2+iw@mail.gmail.com>
	<4DDD4E57.7070800@lerner.co.il>	<4DDD98B6.6080208@pinpointresearch.com>
	<BANLkTin8u2fM+RjE4Ao78v2W83V2Z9iHUA@mail.gmail.com>
	<BANLkTimU=O-vreTUTmC6TV+cA+TyqYqUnQ@mail.gmail.com>
	<BANLkTikoGpWS=S2EFruyWCkGxFoRk7Ms_A@mail.gmail.com>
In-Reply-To: <BANLkTikoGpWS=S2EFruyWCkGxFoRk7Ms_A@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.792 tagged_above=-10 required=5
	tests=BAYES_40=-0.001, RDNS_NONE=0.793
X-Spam-Level: 
X-Archive-Number: 201105/368
X-Sequence-Number: 43877

Wow.

Color me impressed and grateful.  I've been working on a different 
project today, but I'll test these tonight.

I'll never underestimate the regexp functionality in PostgreSQL again!

Reuven