Re: Generic/Ad-Hoc Select Function - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: Generic/Ad-Hoc Select Function
Date
Msg-id 20060604001207.GA22219@wolff.to
Whole thread Raw
In response to Generic/Ad-Hoc Select Function  ("Roy W Bradley" <rbradley@fusiion.com>)
List pgsql-novice
On Sat, Jun 03, 2006 at 11:17:45 -0700,
  Roy W Bradley <rbradley@fusiion.com> wrote:
> I am new to Postgresql and was wondering if it is possible to create an ad-hoc select query function, where the table
name,and the where clause were passed to the function and it returned a result set for the table?   

Yes. You should be able to do this in most of not all of the PLs. A good
start is to read this:
http://developer.postgresql.org/docs/postgres/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN

pgsql-novice by date:

Previous
From: Terry Lee Tucker
Date:
Subject: Re: Generic/Ad-Hoc Select Function
Next
From: Bernard
Date:
Subject: Unable to select pl/java procedural during install