Select Code to Download

  SELECT url,name FROM links

  <a href='$url'>$name</a><br>

CREATE FUNCTION format_link(text,text)
RETURNS text AS '
  return qq[<a href="http://www.domain.com/$_[0]" class="body_link">$_
+[1]</a>];
' LANGUAGE 'plperl';

  SELECT format_link(url,name) FROM links

sfunc_name(type,type)

sfunc_name(type,type,type)

CREATE FUNCTION link_agg (text,text,text)
RETURNS text AS '
  return $_[0] . qq[<a href="http://www.domain.com/$_[0]" class="body_
+link">$_[1]</a><br>];
' LANGUAGE 'plperl';

  SELECT link_agg(url,name) FROM link;