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,
whichis 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 (<alvherre[a]dcc.uchile.cl>)
"Nunca se desea ardientemente lo que solo se desea por razón" (F. Alexandre)