Re: writing a function without installing a language

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: "${spencer}" <spence91(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: writing a function without installing a language
Date: 2008-05-17 18:25:19
Message-ID: 482F230F.2060803@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vlad Kosilov 2008-05-17 18:26:50 pg_standby gets stuck on a smaller wal file
Previous Message Tom Lane 2008-05-17 16:27:39 Re: migration problem