Re: Generic/Ad-Hoc Select Function

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Roy W Bradley <rbradley(at)fusiion(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Generic/Ad-Hoc Select Function
Date: 2006-06-04 00:12:07
Message-ID: 20060604001207.GA22219@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Sat, Jun 03, 2006 at 11:17:45 -0700,
Roy W Bradley <rbradley(at)fusiion(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Bernard 2006-06-04 00:44:43 Unable to select pl/java procedural during install
Previous Message Terry Lee Tucker 2006-06-03 19:08:55 Re: Generic/Ad-Hoc Select Function