Re: decode, base64 problem

On 22.5.20. 18:04, David G. Johnston wrote:
> What makes you believe that you should be able to get a decoded result
> after you've corrupted the encoded data?  You no longer have an
> encoded value, of any length, after doing substring - you now just
> have a sequence of five characters chosen from a subset of ASCII.
>
> David J.
>

OK, I realized my mistake, but now I have a problem again:

select

encode(substring(lice, 110, 5),'base64') as Lokal0,

length(encode(substring(lice, 110, 5),'base64')) as Len05,

decode(encode(substring(lice, 110, 5),'base64')) as Lokal0decode
from grupa002.ispp_partner
where obrisan=0 and maticnibroj=30643;

ERROR:  42883: function decode(text) does not exist
LINE 19: decode(encode(substring(lice, 110, 5),'base64')) as Lokal0de...
         ^
HINT:  No function matches the given name and argument types. You might
need to add explicit type casts.
LOCATION:  ParseFuncOrColumn, parse_func.c:247

Vladimir Kokovic, DP senior (69)
Serbia, Belgrade, May 22, 2020