quick server c question - Mailing list pgsql-admin

Hi all,

My c is rusty and you are all pros!...so...

I want to write a server routine that will return a string so that when "SELECT retstr() from tbl;" is executed this
stringis returned. 

What's the best way to do this?

i.e.

create:

CREATE FUNCTION retstr() RETURNS char???
  AS '/tmp/tst.so' LANGUAGE 'c';

c code:

#include postgres.h
char *  ????
 retstr()
{
    do something
    return string;
}

Thanks for the help,

--
Laurette