From: | gmail Vladimir Koković <vladimir(dot)kokovic(at)gmail(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: decode, base64 problem |
Date: | 2020-05-22 16:35:32 |
Message-ID: | 03e6c185-cee9-3aa6-48dc-ccb43a6da335@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On 22.5.20. 18:29, David G. Johnston wrote:
> On Fri, May 22, 2020 at 9:24 AM gmail Vladimir Koković
> <vladimir(dot)kokovic(at)gmail(dot)com <mailto:vladimir(dot)kokovic(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | David Harrigan | 2020-06-06 07:26:00 | pages_in_range for BRIN index |
Previous Message | David G. Johnston | 2020-05-22 16:29:24 | Re: decode, base64 problem |