Re: Returning Vector of Pairs with a PostgreSQL C ExtensionFunction - Mailing list pgsql-general

From TalGloz
Subject Re: Returning Vector of Pairs with a PostgreSQL C ExtensionFunction
Date
Msg-id 1535371344785-0.post@n3.nabble.com
Whole thread Raw
In response to Re: Returning Vector of Pairs with a PostgreSQL C Extension Function  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Returning Vector of Pairs with a PostgreSQL C ExtensionFunction
List pgsql-general
Hello,

I'm having a small problem. The code works but the array cells don't hold
the whole length of *localT1* and *localT2* texts, I think it has something
to do with *int16 typlen* in my set parameters:

ArrayType *array;
Datum elements[2];
int16 typlen;
bool typbyval;
char typalign;

elements[0] = CStringGetDatum(localT1.c_str());
elements[1] = CStringGetDatum(localT2.c_str());

get_typlenbyvalalign(TEXTOID, &typlen, &typbyval, &typalign);
array = construct_array(elements, 2, TEXTOID, typlen, typbyval, typalign);

I can't change the int16 to int32 or int64 because the
get_typlenbyvalalign() function takes an int16. Is there a way to change my
settings so that each input (in this example the *localT1* and *localT2*)
fits fully in each sell?

Best regards,
Tal



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html


pgsql-general by date:

Previous
From: Tim Clarke
Date:
Subject: archive items not in correct section order
Next
From: TalGloz
Date:
Subject: Re: Returning Vector of Pairs with a PostgreSQL C ExtensionFunction