Обсуждение: Escape variable

Поиск
Список
Период
Сортировка

Escape variable

От
Jaime Rivera
Дата:
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.

Thanks

Jaime



Re: Escape variable

От
Adrian Klaver
Дата:
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