I've got a system for entering and storing a lot of standard hyperlinks in a
compact form, and then expand them at run time like this:
CREATE OR REPLACE FUNCTION _my_expand(TEXT) RETURNS TEXT AS $$
-- private func, expand various compact links
DECLARE
str TEXT = $1;
BEGIN
-- Scanned churc
Leif Biberg Kristensen wrote:
> [...]
> So far, so good. But when I try to do the actual expansion, I'm stumped.
> pgslekt=> select regexp_replace((select source_text from sources where
> source_id=23091), (select quote_literal(short_link) from short_links where
> link_type = 'sk'), (select quot
On Tuesday 27. April 2010 15.04.23 Tim Landscheidt wrote:
> Leif Biberg Kristensen wrote:
>
> > [...]
> > So far, so good. But when I try to do the actual expansion, I'm stumped.
>
> > pgslekt=> select regexp_replace((select source_text from sources where
> > source_id=23091), (select quote_lite
On Tuesday 27. April 2010 13.43.48 Leif Biberg Kristensen wrote:
> CREATE TABLE short_links (
> link_type CHAR(2) PRIMARY KEY,
> short_link TEXT,
> long_link TEXT,
> description TEXT
> );
>
> It appears like I have to double the number of backslashes when I enter the
> data:
>
>
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_REPL
