Thread: BUG #15569: decode function is not correclty working in 10.6

The following bug has been logged on the website:

Bug reference:      15569
Logged by:          Bindu Harikrishnan
Email address:      binduharikrishnanv@gmail.com
PostgreSQL version: 10.6
Operating system:   Ubuntu
Description:

Sir
  I was using postgres 9.4 version. Currenly I chnaged to version 10.6. I
stored image as  bytea datatype . For this purpose I used
decode('','base64')  while insert an image into a table. This code is
working in version 9.4. But when I used the same function in version 10.6 it
return different result. Kindly please help me to over come this issue

=?utf-8?q?PG_Bug_reporting_form?= <noreply@postgresql.org> writes:
>   I was using postgres 9.4 version. Currenly I chnaged to version 10.6. I
> stored image as  bytea datatype . For this purpose I used 
> decode('','base64')  while insert an image into a table. This code is
> working in version 9.4. But when I used the same function in version 10.6 it
> return different result. Kindly please help me to over come this issue

You're not likely to get useful help without being a lot more specific.
In a quick test I don't see any difference in the behavior of decode()
since 9.4, so please show a concrete case where it behaves differently.

One possibility is that it's actually giving the same bytea output,
but it looks different because you have bytea_output set differently
in the two installations.

            regards, tom lane