DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:date:message-id:subject:from:to:content-type;
	b=isxDSm8nvZYdWvZpYF3HbyhzfM6zeBL1N2zw0U0G6daGpyODXjjDT63lSKB18RdPQi
	Aaivsj38KtO9+YxWZO1hy/l8fTyCM4WkGlexIxXJH3e5SLOoOEFLWpIuqysBb+LczKPO
	+bi0CEiKEcnm69rwIImbucOpfVHSd/NZb52rs=
MIME-Version: 1.0
Date: Mon, 1 Mar 2010 22:50:23 +0100
Message-ID: <5eca56861003011350pdc14fa5l2498c260bf68a90c@mail.gmail.com>
Subject: Create functions using a function
From: Gianvito Pio <pio.gianvito@gmail.com>
To: pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary=001485f44fc07594a40480c43c01

--001485f44fc07594a40480c43c01
Content-Type: text/plain; charset=ISO-8859-1

Hi all,
is there a way to define functions and/or triggers in a function?

For example, can I create a function that takes an argument and defines a
function that has the name passed as argument to the first function?

Something like this .....

CREATE FUNCTION test (name varchar) RETURNS VOID AS $$
BEGIN
       CREATE FUNCTION name ( ) (here "name" should be expanded to the
variable content) RETURNS ....
        ...

END
$$

Is there a way to do this? Thanks

--001485f44fc07594a40480c43c01
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi all,<br>is there a way to define functions and/or triggers in a function=
?<br><br>For example, can I create a function that takes an argument and de=
fines a function that has the name passed as argument to the first function=
?<br>
<br>Something like this .....<br><br>CREATE FUNCTION test (name varchar) RE=
TURNS VOID AS $$<br>BEGIN<br>=A0=A0=A0=A0=A0=A0 CREATE FUNCTION name ( ) (h=
ere &quot;name&quot; should be expanded to the variable content) RETURNS ..=
.. <br>=A0=A0=A0=A0=A0=A0=A0 ...<br>
=A0=A0=A0=A0=A0=A0 <br>END<br>$$<br><br>Is there a way to do this? Thanks<b=
r><br>

--001485f44fc07594a40480c43c01--