Re: BUG #15653: pg_detoast_datum_packed problem - Mailing list pgsql-bugs

From gmail Vladimir Koković
Subject Re: BUG #15653: pg_detoast_datum_packed problem
Date
Msg-id 13b4fc8a-b790-ddec-bf02-fe99ed793a5b@gmail.com
Whole thread Raw
In response to BUG #15653: pg_detoast_datum_packed problem  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #15653: pg_detoast_datum_packed problem
List pgsql-bugs
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



pgsql-bugs by date:

Previous
From: gmail Vladimir Koković
Date:
Subject: Re: BUG #15653: pg_detoast_datum_packed problem
Next
From: Andrew Gierth
Date:
Subject: Re: BUG #15653: pg_detoast_datum_packed problem