Saturday, May 17, 2008

Re: [GENERAL] writing a function without installing a language

Craig Ringer wrote:
> ${spencer} wrote:
>> is there a way to write a function without installing a specific
>> language? all i need to do is write a function that can take 3 text's
>> and put them into a list format (eg. "text1, text2 and text3" )

> Failing that, you might be able to use an SQL function (though I don't
> really see how you'd handle the special case for "and" without a
> subquery to obtain a total result count)

... if the input was a set of `text', not 3 individual `text' arguments.
Whoops. It's trivially done with plain SQL.

--
Craig Ringer

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

No comments: