Calling 'c' function from PostGreSQL
От
Atul
Тема
Calling 'c' function from PostGreSQL
Дата
Msg-id
001201c0c0e2$6cb53250$5e05a8c0@atul
Список
Дерево обсуждения
Calling 'c' function from PostGreSQL "Atul" <atulk@newgen.co.in>
Re: Calling 'c' function from PostGreSQL Nabil Sayegh <evolution@sayegh.de>
Re: Calling 'c' function from PostGreSQL Tom Lane <tgl@sss.pgh.pa.us>
Is it possible to call a language 'C' function from a PL/pgSQL function. I have the following code:
// file myfunc.c
#include "postgres.h"
text* myfunc();
text* myfunc()
{
text* ch;
*ch = '1,2';
return ch;
}
{
text* ch;
*ch = '1,2';
return ch;
}
// C file ends here
create function myfunc as
'myfunc.so' langauge 'c';
create function test() returns text as '
declare
at text;
begin
at := myfunc();
return at;
end;
' language 'plpgsql';
at text;
begin
at := myfunc();
return at;
end;
' language 'plpgsql';
The above when executed gives pqReadData()-- backend closed the channel unexpectedly.
В списке pgsql-novice по дате отправления