Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1lTlMO-0007c8-8k
	for pgsql-sql@arkaria.postgresql.org; Tue, 06 Apr 2021 13:03:13 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1lTlMN-0005iK-6D
	for pgsql-sql@arkaria.postgresql.org; Tue, 06 Apr 2021 13:03:11 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <andreas@visena.com>)
	id 1lTlMM-0005iD-K3
	for pgsql-sql@lists.postgresql.org; Tue, 06 Apr 2021 13:03:10 +0000
Received: from post.visena.com ([46.226.10.50])
	by makus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_128_CBC_SHA1:128)
	(Exim 4.92)
	(envelope-from <andreas@visena.com>)
	id 1lTlMJ-0007Bb-7m
	for pgsql-sql@postgresql.org; Tue, 06 Apr 2021 13:03:09 +0000
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=visena.com;
 s=20141101.wh;
	h=Content-Type:MIME-Version:Subject:References:In-Reply-To:Message-ID:Cc:To:From:Date;
 bh=OuCIjAIojBHBUj5n7BhehZkzI05+6dPB3A5iOztAkmM=;
	b=FH7ybLy0nh5xUy9/jsIUPot/+LUZFV63o5dynKGAoEnV7izjYvJYDTa3SuQ/ykdeEzoZAtbOSAI6VCAkvxXOxkbP41+CkfTRMUwJBGfpQconG7y4lTjCAze9RLynwqWRSKI3mNvj/M8chVqdqrIh4nNLSpQWyePWq9k++ceTCEo=;
Received: from tc7-visena.wh.internal.visena.com ([10.0.1.10])
	by post.visena.com with esmtp (Exim 4.82)
	(envelope-from <andreas@visena.com>)
	id 1lTlMF-0005qx-6y; Tue, 06 Apr 2021 15:03:03 +0200
Received: from localhost ([127.0.0.1] helo=tc7-visena.wh.internal.visena.com)
	by tc7-visena.wh.internal.visena.com with esmtp (Exim 4.90_1)
	(envelope-from <andreas@visena.com>)
	id 1lTlMF-0001HZ-3L; Tue, 06 Apr 2021 15:03:03 +0200
Date: Tue, 6 Apr 2021 15:03:02 +0200 (CEST)
From: Andreas Joseph Krogh <andreas@visena.com>
To: MichaelDBA <MichaelDBA@sqlexec.com>
Cc: JORGE MALDONADO <jorgemal1960@gmail.com>, pgsql-sql@postgresql.org
Message-ID: <VisenaEmail.34.12921fa671e91ac5.178a744245a@tc7-visena>
In-Reply-To: <ed9bfcd4-f052-5ccd-5304-b70f8643a171@sqlexec.com>
References: 
 <CAAY=A79T+2DtCt6pv2AKAnP2Azsb6MPLJxZSV0C3GS=AvjOq9g@mail.gmail.com>
 <ed9bfcd4-f052-5ccd-5304-b70f8643a171@sqlexec.com>
Subject: Re: URL Decode function
MIME-Version: 1.0
Content-Type: multipart/mixed;
	boundary="----=_Part_232_1977742188.1617714182870"
X-Mailer: Visena Mail 2.2.612
List-Id: <pgsql-sql.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-sql@lists.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-sql>
Archived-At: 
 <https://www.postgresql.org/message-id/VisenaEmail.34.12921fa671e91ac5.178a744245a%40tc7-visena>
Precedence: bulk

------=_Part_232_1977742188.1617714182870
Content-Type: multipart/related;
	boundary="----=_Part_233_1163974158.1617714182870"

------=_Part_233_1163974158.1617714182870
Content-Type: multipart/alternative;
	boundary="----=_Part_234_1145714330.1617714182990"

------=_Part_234_1145714330.1617714182990
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable


P=C3=A5 tirsdag 06. april 2021 kl. 14:56:10, skrev MichaelDBA <
MichaelDBA@sqlexec.com <mailto:MichaelDBA@sqlexec.com>>: Hi,

 You can create your own "decode" function in pg like this example using=20
varchars as input. Then simply create other overloaded "decode" functions f=
or=20
different input datatypes.
 CREATE OR REPLACE FUNCTION decode(expr varchar, search varchar, result=20
varchar, dflt varchar) RETURNS varchar AS $$ BEGIN CASE WHEN expr =3D searc=
h THEN=20
RETURN result; ELSE RETURN dflt; END CASE; END $$ LANGUAGE plpgsql;=20

Am I the only one who cannot find anything related to the OP's question in=
=20
this answer?=20


I found this on SO:=20

CREATE OR REPLACE FUNCTION decode_url_part(p varchar) RETURNS varchar AS $$=
=20
SELECT convert_from(CAST(E'\\x' || string_agg(CASE WHEN length(r.m[1]) =3D =
1 THEN=20
encode(convert_to(r.m[1], 'SQL_ASCII'), 'hex') ELSE substring(r.m[1] from 2=
 for=20
2) END, '') AS bytea), 'UTF8') FROM regexp_matches($1, '%[0-9a-f][0-9a-f]|.=
',=20
'gi') AS r(m); $$ LANGUAGE SQL IMMUTABLE STRICT;=20

andreak@[local]:5432 13.2 test=3D# select=20
decode_url_part('https%3A%2F%2Fwww.cosmohits.com%2FListasPopularidad%2FList=
aPopularidad%2F1-la-superlista');
=20
=E2=94=8C=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=
=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=
=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=
=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=
=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=
=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=
=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=
=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=
=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=
=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=90
 =E2=94=82 decode_url_part =E2=94=82
=20
=E2=94=9C=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=
=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=
=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=
=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=
=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=
=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=
=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=
=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=
=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=
=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=A4
 =E2=94=82=20
https://www.cosmohits.com/ListasPopularidad/ListaPopularidad/1-la-superlist=
a =E2=94=82
=20
=E2=94=94=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=
=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=
=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=
=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=
=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=
=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=
=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=
=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=
=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=
=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=98
 (1 row)

--
 Andreas Joseph Krogh=20
------=_Part_234_1145714330.1617714182990
Content-Type: text/html;charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div>P=C3=A5 tirsdag 06. april 2021 kl. 14:56:10, skrev MichaelDBA &lt;<a h=
ref=3D"mailto:MichaelDBA@sqlexec.com">MichaelDBA@sqlexec.com</a>&gt;:</div>

<blockquote style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt=
 0pt 0pt 0.8ex; padding-left: 1ex;">Hi,<br>
<br>
You can create your own &quot;decode&quot; function in pg like this example=
 using varchars as input.=C2=A0 Then simply create other overloaded &quot;d=
ecode&quot; functions for different input datatypes.<br>
=C2=A0
<pre style=3D"font-family: monospace, Courier; color: rgb(0, 0, 0); backgro=
und-color: rgb(248, 249, 250); border: 1px solid rgb(234, 236, 240); paddin=
g: 1em; white-space: pre-wrap; line-height: 1.3em; font-size: 14px; font-st=
yle: normal; font-variant-ligatures: normal; font-variant-caps: normal; fon=
t-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-=
indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-te=
xt-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-s=
tyle: initial; text-decoration-color: initial;">
CREATE OR REPLACE FUNCTION decode(expr varchar, search varchar, result varc=
har, dflt varchar) RETURNS varchar AS
$$     =20
BEGIN
CASE WHEN expr =3D search THEN RETURN result; ELSE RETURN dflt; END CASE;
END
$$ LANGUAGE plpgsql;</pre>
</blockquote>

<div>=C2=A0</div>

<div>Am I the only one who cannot find anything related to the OP's questio=
n in this answer?</div>

<div class=3D"visena-email-signature" data-visena-message-id=3D"&lt;VisenaE=
mail.34.12921fa671e91ac5.178a744245a@tc7-visena>">
<div>=C2=A0</div>

<div>I found this on SO:</div>

<div>=C2=A0</div>

<div>
<pre class=3D"lang-sql s-code-block hljs" style=3D"margin-top: 0px; margin-=
bottom: calc(var(--s-prose-spacing) + 0.4em); padding: 12px; border: 0px; f=
ont-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretc=
h: inherit; line-height: 1.30769; font-family: Consolas, Menlo, Monaco, &qu=
ot;Lucida Console&quot;, &quot;Liberation Mono&quot;, &quot;DejaVu Sans Mon=
o&quot;, &quot;Bitstream Vera Sans Mono&quot;, &quot;Courier New&quot;, mon=
ospace, sans-serif; font-size: 13px; vertical-align: baseline; box-sizing: =
inherit; width: auto; max-height: 600px; overflow: auto; background-color: =
var(--highlight-bg); border-radius: 5px; color: var(--highlight-color); ove=
rflow-wrap: normal;">
<code style=3D"margin: 0px; padding: 0px; border: 0px; font-style: inherit;=
 font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-h=
eight: inherit; font-family: inherit; vertical-align: baseline; box-sizing:=
 inherit; background-color: transparent; white-space: inherit;"><span class=
=3D"hljs-keyword" style=3D"margin: 0px; padding: 0px; border: 0px; font-sty=
le: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inh=
erit; line-height: inherit; font-family: inherit; vertical-align: baseline;=
 box-sizing: inherit; color: var(--highlight-keyword);">CREATE</span> <span=
 class=3D"hljs-keyword" style=3D"margin: 0px; padding: 0px; border: 0px; fo=
nt-style: inherit; font-variant: inherit; font-weight: inherit; font-stretc=
h: inherit; line-height: inherit; font-family: inherit; vertical-align: bas=
eline; box-sizing: inherit; color: var(--highlight-keyword);">OR</span> REP=
LACE <span class=3D"hljs-keyword" style=3D"margin: 0px; padding: 0px; borde=
r: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; f=
ont-stretch: inherit; line-height: inherit; font-family: inherit; vertical-=
align: baseline; box-sizing: inherit; color: var(--highlight-keyword);">FUN=
CTION</span> decode_url_part(p <span class=3D"hljs-type" style=3D"margin: 0=
px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; =
font-weight: inherit; font-stretch: inherit; line-height: inherit; font-fam=
ily: inherit; vertical-align: baseline; box-sizing: inherit; color: var(--h=
ighlight-namespace);">varchar</span>) <span class=3D"hljs-keyword" style=3D=
"margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant:=
 inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit=
; font-family: inherit; vertical-align: baseline; box-sizing: inherit; colo=
r: var(--highlight-keyword);">RETURNS</span> <span class=3D"hljs-type" styl=
e=3D"margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-vari=
ant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inh=
erit; font-family: inherit; vertical-align: baseline; box-sizing: inherit; =
color: var(--highlight-namespace);">varchar</span> <span class=3D"hljs-keyw=
ord" style=3D"margin: 0px; padding: 0px; border: 0px; font-style: inherit; =
font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-he=
ight: inherit; font-family: inherit; vertical-align: baseline; box-sizing: =
inherit; color: var(--highlight-keyword);">AS</span> $$
<span class=3D"hljs-keyword" style=3D"margin: 0px; padding: 0px; border: 0p=
x; font-style: inherit; font-variant: inherit; font-weight: inherit; font-s=
tretch: inherit; line-height: inherit; font-family: inherit; vertical-align=
: baseline; box-sizing: inherit; color: var(--highlight-keyword);">SELECT</=
span> convert_from(<span class=3D"hljs-built_in" style=3D"margin: 0px; padd=
ing: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-wei=
ght: inherit; font-stretch: inherit; line-height: inherit; font-family: inh=
erit; vertical-align: baseline; box-sizing: inherit; color: var(--highlight=
-literal);">CAST</span>(E<span class=3D"hljs-string" style=3D"margin: 0px; =
padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font=
-weight: inherit; font-stretch: inherit; line-height: inherit; font-family:=
 inherit; vertical-align: baseline; box-sizing: inherit; color: var(--highl=
ight-variable);">'\\x'</span> <span class=3D"hljs-operator" style=3D"margin=
: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inheri=
t; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-=
family: inherit; vertical-align: baseline; box-sizing: inherit;">||</span> =
string_agg(<span class=3D"hljs-keyword" style=3D"margin: 0px; padding: 0px;=
 border: 0px; font-style: inherit; font-variant: inherit; font-weight: inhe=
rit; font-stretch: inherit; line-height: inherit; font-family: inherit; ver=
tical-align: baseline; box-sizing: inherit; color: var(--highlight-keyword)=
;">CASE</span> <span class=3D"hljs-keyword" style=3D"margin: 0px; padding: =
0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: =
inherit; font-stretch: inherit; line-height: inherit; font-family: inherit;=
 vertical-align: baseline; box-sizing: inherit; color: var(--highlight-keyw=
ord);">WHEN</span> length(r.m[<span class=3D"hljs-number" style=3D"margin: =
0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit;=
 font-weight: inherit; font-stretch: inherit; line-height: inherit; font-fa=
mily: inherit; vertical-align: baseline; box-sizing: inherit; color: var(--=
highlight-namespace);">1</span>]) <span class=3D"hljs-operator" style=3D"ma=
rgin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: in=
herit; font-weight: inherit; font-stretch: inherit; line-height: inherit; f=
ont-family: inherit; vertical-align: baseline; box-sizing: inherit;">=3D</s=
pan> <span class=3D"hljs-number" style=3D"margin: 0px; padding: 0px; border=
: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; fo=
nt-stretch: inherit; line-height: inherit; font-family: inherit; vertical-a=
lign: baseline; box-sizing: inherit; color: var(--highlight-namespace);">1<=
/span> <span class=3D"hljs-keyword" style=3D"margin: 0px; padding: 0px; bor=
der: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit;=
 font-stretch: inherit; line-height: inherit; font-family: inherit; vertica=
l-align: baseline; box-sizing: inherit; color: var(--highlight-keyword);">T=
HEN</span> encode(convert_to(r.m[<span class=3D"hljs-number" style=3D"margi=
n: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inher=
it; font-weight: inherit; font-stretch: inherit; line-height: inherit; font=
-family: inherit; vertical-align: baseline; box-sizing: inherit; color: var=
(--highlight-namespace);">1</span>], <span class=3D"hljs-string" style=3D"m=
argin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: i=
nherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; =
font-family: inherit; vertical-align: baseline; box-sizing: inherit; color:=
 var(--highlight-variable);">'SQL_ASCII'</span>), <span class=3D"hljs-strin=
g" style=3D"margin: 0px; padding: 0px; border: 0px; font-style: inherit; fo=
nt-variant: inherit; font-weight: inherit; font-stretch: inherit; line-heig=
ht: inherit; font-family: inherit; vertical-align: baseline; box-sizing: in=
herit; color: var(--highlight-variable);">'hex'</span>) <span class=3D"hljs=
-keyword" style=3D"margin: 0px; padding: 0px; border: 0px; font-style: inhe=
rit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; li=
ne-height: inherit; font-family: inherit; vertical-align: baseline; box-siz=
ing: inherit; color: var(--highlight-keyword);">ELSE</span> <span class=3D"=
hljs-built_in" style=3D"margin: 0px; padding: 0px; border: 0px; font-style:=
 inherit; font-variant: inherit; font-weight: inherit; font-stretch: inheri=
t; line-height: inherit; font-family: inherit; vertical-align: baseline; bo=
x-sizing: inherit; color: var(--highlight-literal);">substring</span>(r.m[<=
span class=3D"hljs-number" style=3D"margin: 0px; padding: 0px; border: 0px;=
 font-style: inherit; font-variant: inherit; font-weight: inherit; font-str=
etch: inherit; line-height: inherit; font-family: inherit; vertical-align: =
baseline; box-sizing: inherit; color: var(--highlight-namespace);">1</span>=
] <span class=3D"hljs-keyword" style=3D"margin: 0px; padding: 0px; border: =
0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font=
-stretch: inherit; line-height: inherit; font-family: inherit; vertical-ali=
gn: baseline; box-sizing: inherit; color: var(--highlight-keyword);">from</=
span> <span class=3D"hljs-number" style=3D"margin: 0px; padding: 0px; borde=
r: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; f=
ont-stretch: inherit; line-height: inherit; font-family: inherit; vertical-=
align: baseline; box-sizing: inherit; color: var(--highlight-namespace);">2=
</span> <span class=3D"hljs-keyword" style=3D"margin: 0px; padding: 0px; bo=
rder: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit=
; font-stretch: inherit; line-height: inherit; font-family: inherit; vertic=
al-align: baseline; box-sizing: inherit; color: var(--highlight-keyword);">=
for</span> <span class=3D"hljs-number" style=3D"margin: 0px; padding: 0px; =
border: 0px; font-style: inherit; font-variant: inherit; font-weight: inher=
it; font-stretch: inherit; line-height: inherit; font-family: inherit; vert=
ical-align: baseline; box-sizing: inherit; color: var(--highlight-namespace=
);">2</span>) <span class=3D"hljs-keyword" style=3D"margin: 0px; padding: 0=
px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: i=
nherit; font-stretch: inherit; line-height: inherit; font-family: inherit; =
vertical-align: baseline; box-sizing: inherit; color: var(--highlight-keywo=
rd);">END</span>, <span class=3D"hljs-string" style=3D"margin: 0px; padding=
: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight=
: inherit; font-stretch: inherit; line-height: inherit; font-family: inheri=
t; vertical-align: baseline; box-sizing: inherit; color: var(--highlight-va=
riable);">''</span>) <span class=3D"hljs-keyword" style=3D"margin: 0px; pad=
ding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-we=
ight: inherit; font-stretch: inherit; line-height: inherit; font-family: in=
herit; vertical-align: baseline; box-sizing: inherit; color: var(--highligh=
t-keyword);">AS</span> bytea), <span class=3D"hljs-string" style=3D"margin:=
 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit=
; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-f=
amily: inherit; vertical-align: baseline; box-sizing: inherit; color: var(-=
-highlight-variable);">'UTF8'</span>)
<span class=3D"hljs-keyword" style=3D"margin: 0px; padding: 0px; border: 0p=
x; font-style: inherit; font-variant: inherit; font-weight: inherit; font-s=
tretch: inherit; line-height: inherit; font-family: inherit; vertical-align=
: baseline; box-sizing: inherit; color: var(--highlight-keyword);">FROM</sp=
an> regexp_matches($<span class=3D"hljs-number" style=3D"margin: 0px; paddi=
ng: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weig=
ht: inherit; font-stretch: inherit; line-height: inherit; font-family: inhe=
rit; vertical-align: baseline; box-sizing: inherit; color: var(--highlight-=
namespace);">1</span>, <span class=3D"hljs-string" style=3D"margin: 0px; pa=
dding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-w=
eight: inherit; font-stretch: inherit; line-height: inherit; font-family: i=
nherit; vertical-align: baseline; box-sizing: inherit; color: var(--highlig=
ht-variable);">'%[0-9a-f][0-9a-f]|.'</span>, <span class=3D"hljs-string" st=
yle=3D"margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-va=
riant: inherit; font-weight: inherit; font-stretch: inherit; line-height: i=
nherit; font-family: inherit; vertical-align: baseline; box-sizing: inherit=
; color: var(--highlight-variable);">'gi'</span>) <span class=3D"hljs-keywo=
rd" style=3D"margin: 0px; padding: 0px; border: 0px; font-style: inherit; f=
ont-variant: inherit; font-weight: inherit; font-stretch: inherit; line-hei=
ght: inherit; font-family: inherit; vertical-align: baseline; box-sizing: i=
nherit; color: var(--highlight-keyword);">AS</span> r(m);
$$ <span class=3D"hljs-keyword" style=3D"margin: 0px; padding: 0px; border:=
 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; fon=
t-stretch: inherit; line-height: inherit; font-family: inherit; vertical-al=
ign: baseline; box-sizing: inherit; color: var(--highlight-keyword);">LANGU=
AGE</span> <span class=3D"hljs-keyword" style=3D"margin: 0px; padding: 0px;=
 border: 0px; font-style: inherit; font-variant: inherit; font-weight: inhe=
rit; font-stretch: inherit; line-height: inherit; font-family: inherit; ver=
tical-align: baseline; box-sizing: inherit; color: var(--highlight-keyword)=
;">SQL</span> IMMUTABLE STRICT;
</code></pre>

<div>=C2=A0</div>
</div>

<div><span style=3D"font-family:monospace"><span style=3D"color: rgb(178, 2=
4, 178);">andreak@[local]:5432</span><span style=3D"color: rgb(0, 0, 0);"> =
13.2 </span><span style=3D"color: rgb(24, 178, 24);">test</span><span style=
=3D"color: rgb(0, 0, 0);">=3D# select decode_url_part('https%3A%2F%2Fwww.co=
smohits.com%2FListasPopularidad%2FListaPopularidad%2F1-la-superlista'); </s=
pan><br>
=E2=94=8C=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=
=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=
=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=
=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=
=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=
=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=
=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=
=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=
=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=
=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=90<br>
=E2=94=82 =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0decode_url_part =C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=E2=94=82<br>
=E2=94=9C=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=
=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=
=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=
=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=
=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=
=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=
=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=
=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=
=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=
=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=A4<br>
=E2=94=82 https://www.cosmohits.com/ListasPopularidad/ListaPopularidad/1-la=
-superlista =E2=94=82<br>
=E2=94=94=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=
=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=
=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=
=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=
=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=
=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=
=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=
=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=
=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=
=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=98<br>
(1 row)</span><br>
=C2=A0</div>

<div>--<br>
Andreas Joseph Krogh</div>
</div>
------=_Part_234_1145714330.1617714182990--

------=_Part_233_1163974158.1617714182870--

------=_Part_232_1977742188.1617714182870--