Re: quotes in pl/pgsql

Hi Najm,

Is this what you mean?

CREATE FUNCTION foobar(int4) returns int4 as 'DECLARE
 textbuf   varchar(120);

BEGIN
   textbuf := ''Example Text '';
   insert into sometable (something) values (textbuf);
   RETURN 0; END;'
LANGUAGE 'plpgsql';


Najm Hashmi wrote:
> 
> Hi all, I just want to know how to put quotes around a string. Is there a
> function to do so?
> If not how can I escape  a single quote.
> Thank you in advance.
> 
>   ------------------------------------------------------------------------
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org