Hi,
/* SQL function: bvarchar(varchar) returns bytea */
PG_FUNCTION_INFO_V1(pg_bvarchar);
Datum pg_bvarchar(PG_FUNCTION_ARGS) {
VarChar *arg = PG_GETARG_VARCHAR_PP(0);
unsigned len;
bytea *res;
len = VARSIZE( arg ) - VARHDRSZ;
res = (text *)palloc( len + VARHDRSZ );
SET_VARSIZE( res, len + VARHDRSZ );
memcpy( VARDATA( res ), VARDATA( arg ), len);
PG_RETURN_BYTEA_P(res);
}
Vladimir Koković, DP senior(69)
Belgrade, Mar. 1 2019