Received: from maia.hub.org (maia-1.hub.org [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 6E696632C2E
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 27 Apr 2010 11:19:13 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 23561-03 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 27 Apr 2010 14:18:53 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail45.e.nsc.no (mail45.e.nsc.no [193.213.115.45])
	by mail.postgresql.org (Postfix) with ESMTP id 434E963279B
	for <pgsql-sql@postgresql.org>; Tue, 27 Apr 2010 11:19:01 -0300 (ADT)
Received: from balapapa.localnet (42.185.16.62.customer.cdi.no [62.16.185.42])
	(authenticated bits=0)
	by mail45.nsc.no (8.14.3/8.14.3) with ESMTP id o3REIwUs001425
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT)
	for <pgsql-sql@postgresql.org>; Tue, 27 Apr 2010 16:18:59 +0200 (MEST)
From: Leif Biberg Kristensen <leif@solumslekt.org>
To: pgsql-sql@postgresql.org
Subject: Re: regexp_replace and search/replace values stored in table
Date: Tue, 27 Apr 2010 16:18:57 +0200
User-Agent: KMail/1.12.4 (Linux/2.6.32-gentoo-r7; KDE/4.3.5; i686; ; )
References: <201004271343.48070.leif@solumslekt.org>
	<201004271532.20639.leif@solumslekt.org>
In-Reply-To: <201004271532.20639.leif@solumslekt.org>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Message-Id: <201004271618.57658.leif@solumslekt.org>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.8 tagged_above=-10 required=5 tests=BAYES_50=0.8
X-Spam-Level: 
X-Archive-Number: 201004/100
X-Sequence-Number: 34027

Followup. Replaced Big Ugly Function with:

CREATE OR REPLACE FUNCTION _my_expand(TEXT) RETURNS TEXT AS $$
-- private func, expand various compact links
DECLARE
    str TEXT = $1;
    links RECORD;

BEGIN
    FOR links IN SELECT short_link, long_link FROM short_links LOOP
        str := REGEXP_REPLACE(str, links.short_link, links.long_link, 'g');
    END LOOP;
    RETURN str;
END
$$ LANGUAGE plpgsql IMMUTABLE;

By the way, those who haven't read this gem should probably do so: 
<http://database-programmer.blogspot.com/2008/05/minimize-code-maximize-
data.html>

regards,
-- 
Leif Biberg Kristensen
http://solumslekt.org/