Re: C Programming with postgres.h - my function crashes the database backend

On Tue, Dec 02, 2003 at 05:56:45PM +0000, Alex Page wrote:

>   Datum enum_gender_in(PG_FUNCTION_ARGS) {
>   	text	*invalue = PG_GETARG_TEXT_P(0);
>   
>   	if ( strcmp ( VARDATA(invalue), "Male" ) ) {		/* VARDATA gets the data portion of a "varlena" struct, which is typedef'd to "text" */
>   		PG_RETURN_INT32( 0 );
>   	}
>   	PG_RETURN_INT32( 1 );
>   }

VARDATA is not 0-terminated, so you can't use strcmp on it.  Maybe you
should use memcmp instead.

-- 
Alvaro Herrera ()
"Nunca se desea ardientemente lo que solo se desea por razón" (F. Alexandre)