Le portail francophone de la géomatique

Hi
I'm writing new basic type written with C with postgresql, this is a geospatial type which contains timestamp,char * and spatial(point,linestring) attributes.
I tried the complex example and it works well on postgresql server 8.3 but when I made my type I have problems with input and output functions,
The type should be like that

typedef struct mytype
{
    char *        type;
    timestamp*         te;
    timestamp*         ts;
    geometry *       l;
}    Mytype;

I don't what libraries should be included to get timestamp type

Datum
mytype_in(PG_FUNCTION_ARGS)
{
    char       *str = PG_GETARG_CSTRING(0);
    char        *l1,*te1,*ts1;
    char        *type1 ;
    Mytype*result;
   

    if (sscanf(str, "( %s )", type1, te1,ts1,l1) != 4)
        ereport(ERROR,
                (errcode(ERRCODE_INVALID_TEXT_REPRESENTATION),
                 errmsg("invalid input syntax for mytype: \"%s\"",
                        str)));

    result = (Mytype*) palloc(sizeof(Mytype));
   
    result->te = te1;
    result->ts = ts1;
    result->type = type1;
    PG_RETURN_POINTER(result);
}

PG_FUNCTION_INFO_V1(mytype_out);

Datum
mytype_out(PG_FUNCTION_ARGS)
{
    Mytype *mytype= (Mytype*) PG_GETARG_POINTER(0);
    char       *result;

    result = (char *) palloc(1000);
    snprintf(result, 100, "( %s , %s , %s , %s )",mytype ->type, mytype->te,mytype->ts,mytype->l);
    PG_RETURN_CSTRING(result);
}

Please tell me what's wrong with this definition, there is no compilation problem, I created a table with mytype attribute insert works well but when I select data from this table postgresql server goes down and restart

Thank you in advance


Best Regards
SETHOM Ahmed Amin
Mobile: + 216 40 175 841 begin_of_the_skype_highlighting              + 216 40 175 841      end_of_the_skype_highlighting