Stored procedures returning TEXT

Поиск
Список
Период
Сортировка
От Céline Rivière
Тема Stored procedures returning TEXT
Дата
Msg-id 0b7101c1c066$6ec1b3f0$c7a638d5@fr.netcentrex.net
обсуждение исходный текст
Список pgsql-sql
Hello,
 
In 1999, someone asked you about the following problem. I have exactly the
same and couldn't solve it. Could you help me ?
 
Thanks.

Céline
 
---------------------------------------------------------------------
 
Preinstalled postgresql-6.4.2 on Linux-Elf
Who know how write function(language 'c') which return text type?
I try
#include "postgres.h"

text test(text *t)
{
return(*t);
}
...
made test.so,
create function test(text) returns text as 'path_to_test.so' language
'c'
and finaly
pgsql
test=>select test('abc');
pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally before or
while processing the request.
We have lost the connection to the backend, so further processing is
impossible.  Terminating.
Anybody have some examples working text-type c-functions?
Please send me if you have

В списке pgsql-sql по дате отправления:

Предыдущее
От: "Dan Langille"
Дата:
Сообщение: Re: Uniqueness of rule, constraint, and trigger names
Следующее
От: Céline Rivière
Дата:
Сообщение: CREATE FUNCTION and LANGUAGE 'C'