From: | MichaelDBA <MichaelDBA(at)sqlexec(dot)com> |
---|---|
To: | JORGE MALDONADO <jorgemal1960(at)gmail(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: URL Decode function |
Date: | 2021-04-06 12:56:10 |
Message-ID: | ed9bfcd4-f052-5ccd-5304-b70f8643a171@sqlexec.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi,
You can create your own "decode" function in pg like this example using
varchars as input. Then simply create other overloaded "decode"
functions for different input datatypes.
CREATE OR REPLACE FUNCTION decode(expr varchar, search varchar, result varchar, dflt varchar) RETURNS varchar AS
$$
BEGIN
CASE WHEN expr = search THEN RETURN result; ELSE RETURN dflt; END CASE;
END
$$ LANGUAGE plpgsql;
Regards,
Michael Vitale
JORGE MALDONADO wrote on 4/6/2021 12:34 AM:
> Hi,
>
> In my DB, one of my tables has a field that is URL Encoded (its value
> is a URL of course).
>
> For example, the value:
> *https://www.cosmohits.com/ListasPopularidad/ListaPopularidad/1-la-superlista*
> is URL Encoded like this:
> *https%3A%2F%2Fwww.cosmohits.com
> <http://2Fwww.cosmohits.com>%2FListasPopularidad%2FListaPopularidad%2F1-la-superlista
> *
>
> Is there a PostgreSQL function to URL Decode such field when
> performing a SELECT statement? I have not found anything in documentation.
>
> Best regards,
> Jorge Maldonado
>
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon>
> Virus-free. www.avast.com
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Joseph Krogh | 2021-04-06 13:03:02 | Re: URL Decode function |
Previous Message | JORGE MALDONADO | 2021-04-06 04:34:19 | URL Decode function |