Re: decode, base64 problem - Mailing list pgsql-novice

On Fri, May 22, 2020 at 9:24 AM gmail Vladimir Koković <vladimir.kokovic@gmail.com> wrote:

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

You forgot the second argument to decode...

David J.

You are right, so definitely select works properly, thank you very much.

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'),'base64') as Lokal0decode
from grupa002.ispp_partner
where obrisan=0 and maticnibroj=30643;

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