DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=YYbYDf6uvtK1o4YeVLzzQwZKXuB9JGuVsYp7j3UA5jL5ULUhKzdN0PnfStTw5oYyDYJRywNjvHXto2j8+Xzt1xsKt/CsovSjZ2MwC2uDRtJvtvvbywDj33CunBewtvkXzQ/5XRmjfRwcd1eD2Ibtluma9lTIEL27Gs8zGHZy4Vc=
Message-ID: <a55915760705150014y538341dj2fc5aef0500fd689@mail.gmail.com>
Date: Tue, 15 May 2007 02:14:57 -0500
From: "=?ISO-8859-1?Q?Rodrigo_De_Le=F3n?=" <rdeleonp@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: How to process inverted comma in "EXECUTE 'insert into xxx
	values(...)
Cc: "Nemo Terry" <ntuser155@hotmail.com>
In-Reply-To: <BAY19-F7C1E88EB8DBB10FEBC7D1F53D0@phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <a55915760705142325u33359969wef53e8bd20bdbc11@mail.gmail.com>
	<BAY19-F7C1E88EB8DBB10FEBC7D1F53D0@phx.gbl>

On 5/15/07, Nemo Terry <ntuser155@hotmail.com> wrote:
> But I must use it in function,so...
> Do you have another solution?

So?

----------------------------------------

t=# CREATE TABLE d(i INT);
CREATE TABLE
t=# CREATE OR REPLACE FUNCTION add1(x INT) RETURNS INT AS
t-# $$
t$# BEGIN
t$#   INSERT INTO d VALUES(x);
t$#   RETURN x;
t$# END;
t$# $$ LANGUAGE plpgsql;
CREATE FUNCTION
t=# SELECT add1(1);
    1

t=# SELECT add1(2);
    2

t=# SELECT add1(3);
    3

t=# SELECT * FROM d;
 1
 2
 3

----------------------------------------

Do you need something else?