Sql query as input variable in a PL/pgsql function?

From: "Tjibbe Rijpma" <t(dot)b(dot)rijpma(at)student(dot)tudelft(dot)nl>
To: "PostgreSQL Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Sql query as input variable in a PL/pgsql function?
Date: 2005-01-17 13:33:41
Message-ID: 012801c4fc99$295d9050$0100a8c0@TJIBBE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Is is possible to maka a PL/pgsql function which can receive a random SQL
query as input variable?

Like this:

SELECT save_query ('SELECT * FROM objects, names WHERE objects.id =
names.id);

And than execute the SQL query inside the function.

Tjibbe

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2005-01-17 13:58:02 Re: Sql query as input variable in a PL/pgsql function?
Previous Message Adie 2005-01-17 12:22:23 Re: Common question: what's wrong