RE: [GENERAL] postgresql v6.4.2 c funcs and null text pointers...

-----Original Message-----
I wrote a c func (ATTACHED BELOW) which takes 2 pointers to
type text, and
a bool field. When a field in a row passed to the func is
null, espically
the 'first' field, Postgresql does not return the value that my code
produced.

For example:
First lastco nocompany
------------------------------------------
NULL Walt Bigelow True

the above data is contained in the database, and when passed
to my c func
like:

SELECT lastfirst(first, lastco, nocompany) as name from
tbladdress where
agencyid = 691;

I get:
name
----

(1 row)

Not the expected output of 'Walt Bigelow, '.

When I update that row with first = '', the result is correct, but the
value is no null, so it works.

What am I missing??

Any help is appricated,
Walt

-------------
name.c:

#include <string.h>
#include "postgres.h"

#define COMMA ", "

text *lastfirst (text *first, text *last, bool nocompany)
{
/* this function will take in the first name, and last name
* and based on nocompany set the output to either return
* 'last, first' or just the company name.
*/

int32 ret_size;
text *return_text;

if (nocompany) {

if (first == NULL) {

ret_size = VARSIZE(last) + sizeof(COMMA);
return_text = (text *) palloc(ret_size);

memset(return_text, 0, ret_size);

VARSIZE(return_text) = ret_size;

strncpy (VARDATA(return_text), VARDATA(last),
VARSIZE(last)-VARHDRSZ);

strncat (VARDATA(return_text), COMMA,
sizeof(COMMA));

return (return_text);

} else {

ret_size = VARSIZE(first) + VARSIZE(last) +
sizeof(COMMA) - VARHDRSZ;

return_text = (text *) palloc(ret_size);

memset(return_text, 0, ret_size);

VARSIZE(return_text) = ret_size;

strncpy (VARDATA(return_text),
VARDATA(last), VARSIZE(last)-VARHDRSZ);
strncat (VARDATA(return_text), COMMA,
sizeof(COMMA));
strncat (VARDATA(return_text),
VARDATA(first), VARSIZE(first)-VARHDRSZ);

return (return_text);

}

} else {
/* Just the company name is returned here */

ret_size = VARSIZE(last);
return_text = (text *) palloc(ret_size);

VARSIZE(return_text) = ret_size;
strncpy(VARDATA(return_text), VARDATA(last),
VARSIZE(last)-VARHDRSZ);

return (return_text);
}
}