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

2008-05-19 Thread ${spencer}
thanks for the help guys, i've solved the problem using PL/PgSQL. once i had "created" the language it was really rather simple. thanks again -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-gener

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

2008-05-17 Thread Craig Ringer
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 (t

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

2008-05-17 Thread Leif B. Kristensen
On Friday 16. May 2008, ${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" ) > >can anyone help? sandbox=> create function foo(text

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

2008-05-17 Thread Craig Ringer
${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" ) Does PL/PgSQL count as a "language" for your purposes? PL/PgSQL is built and

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

2008-05-16 Thread Adrian Klaver
On Friday 16 May 2008 7:56 am, ${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" ) > > can anyone help? You can use C or SQL to

[GENERAL] writing a function without installing a language

2008-05-16 Thread ${spencer}
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" ) can anyone help? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make ch