[HACKERS] ERROR: index row size

[Rodrigo Sakai]

  Hello,

 

  Ok, I give up! Tried a lot of things in my code! But still get error on
index row size. So, I'm part of my code, if someone could help me! A valid
value for this type is: '(03-jan-2007 , 15-may-2010)'

 

typedef struct t_periodo

{

      DateADT           tvi;

      DateADT           tvf;

}     Periodo;

 

Datum

periodo_in(PG_FUNCTION_ARGS)

{

    char    *str = PG_GETARG_CSTRING(0);

    char    tvi_char[MAXDATEFIELDS];

    char    tvf_char[MAXDATEFIELDS];

    

    tvi_char = (char *) palloc(strlen(MAXDATEFIELDS));

    tvf_char = (char *) palloc(strlen(MAXDATEFIELDS));

    

    Periodo     *result;

    

    if (sscanf(str, " ( %s , %s )", tvi_char, tvf_char) != 2)

        ereport(ERROR,

            (errcode(ERRCODE_INVALID_TEXT_REPRESENTATION),

            errmsg("invalid input syntax for periodo: \"%s\"", str)));

            

    result->tvi = StringToDateADT(tvi_char);            

    result->tvi = StringToDateADT(tvf_char);

    

    result = (Periodo *) palloc(sizeof(Periodo));

      

    if (result->tvi > result->tvf)

        ereport(ERROR,

                (errcode(ERRCODE_INVALID_TEXT_REPRESENTATION),

                errmsg("Initial date (TVi) must be smaller than final date
(TVf)")));      

    

    PG_RETURN_POINTER(result);

}

 

 

  Please help me!

  Thanks in advance!