Re: decode, base64 problem

=?UTF-8?Q?gmail_Vladimir_Kokovi=c4=87?= <vladimir(dot)kokovic(at)gmail(dot)com> writes:
> I don't know what this is about, so I could get from someone who knows
> more PostgreSQL than I do,

base64 translates groups of three bytes into groups of 4 characters, so
you can't just randomly chop the result at spots that aren't multiples of
4. Even if the result happens to look like valid base64 data, the decode
output would be wrong, with bits incorrectly reassembled into bytes.

I'd recommend decoding the whole base64 string and then substring'ing
the result of that.

regards, tom lane