On 10/27/2016 08:57 AM, Jaime Rivera wrote:
> Hello,
>
> I've been looking for a way to escape a variable inside a plpgsql stored
> procedure just like E works with constants.
>
> For example :
>
> * select E'Se recibi\u00f3 a \n ci\u00f3n.' *
>
> Returns:
>
> /*Se recibió a */
> /* ción.*/
Something like?:
DO $$
DECLARE
esc_str varchar;
BEGIN
esc_str = E'Se recibi\u00f3 a \n ci\u00f3n.' ;
RAISE NOTICE '%', esc_str;
END;
$$ LANGUAGE plpgsql;
NOTICE: Se recibió a
ción.
DO
If not then can you show an example from in plpgsql?
>
> Thanks
>
> Jaime
>
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com