By the way, the simplest way (and probably fastest) to do this from Perl is:
pack("H*", substr($value, 2));
and it works with hex output of bytea columns (newer versions of
PostgreSQL).
Best regards,
Dmitriy Shalashov
2013/12/17 Bugs in DBD-Pg via RT <bug-DBD-Pg@rt.cpan.org>
Show quoted text>
> Greetings,
>
> This message has been automatically generated in response to the
> creation of a trouble ticket regarding:
> "arrays of bytea not decoded automatically",
> a summary of which appears below.
>
> There is no need to reply to this message right now. Your ticket has been
> assigned an ID of [rt.cpan.org #91454]. Your ticket is accessible
> on the web at:
>
>
https://rt.cpan.org/Ticket/Display.html?id=91454
>
> Please include the string:
>
> [rt.cpan.org #91454]
>
> in the subject line of all future correspondence about this issue. To do
> so,
> you may reply to this message.
>
> Thank you,
> bug-DBD-Pg@rt.cpan.org
>
> -------------------------------------------------------------------------
> after query
>
> SELECT bytearray[1] FROM test
>
> column will be decoded;
> after another one
>
> SELECT bytearray FROM test
>
> content of array isn't decoded.
> And I'm not sure if dequote_bytea is available from Perl...
> Anyway it seems to be a good idea to decode arrays too.
>
> Best regards,
> Dmitriy Shalashov
>
RT for rt.cpan.org