From: | "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov> |
---|---|
To: | "Tjibbe Rijpma" <t(dot)b(dot)rijpma(at)student(dot)tudelft(dot)nl>, "PostgreSQL Novice" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Sql query as input variable in a PL/pgsql function? |
Date: | 2005-01-17 13:58:02 |
Message-ID: | 007d01c4fc9c$8fb10fa0$7d75f345@WATSON |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
See this section of the manual:
Sean
----- Original Message -----
From: "Tjibbe Rijpma" <t(dot)b(dot)rijpma(at)student(dot)tudelft(dot)nl>
To: "PostgreSQL Novice" <pgsql-novice(at)postgresql(dot)org>
Sent: Monday, January 17, 2005 8:33 AM
Subject: [NOVICE] Sql query as input variable in a PL/pgsql function?
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-01-17 15:42:53 | Re: Change the name of the database |
Previous Message | Tjibbe Rijpma | 2005-01-17 13:33:41 | Sql query as input variable in a PL/pgsql function? |