Thread: Generic/Ad-Hoc Select Function
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?
Thanks
Roy
On Saturday 03 June 2006 02:17 pm, "Roy W Bradley" <rbradley@fusiion.com> thus communicated: --> 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? --> --> Thanks --> Roy --> You can generate dynamic SELECT statements. See the docs at: http://www.postgresql.org/docs/8.1/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
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