| From: | Joe Conway <mail(at)joeconway(dot)com> |
|---|---|
| To: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
| Cc: | "Little, Douglas" <DOUGLAS(dot)LITTLE(at)orbitz(dot)com>, "PostgreSQL General (pgsql-general(at)postgresql(dot)org)" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: evaluating expressions stored in table |
| Date: | 2012-12-18 16:56:59 |
| Message-ID: | 50D0A05B.6010309@joeconway.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 12/18/2012 08:50 AM, Merlin Moncure wrote:
> On Tue, Dec 18, 2012 at 10:03 AM, Little, Douglas
> Anybody have any comments?
>
> probably you need a pl/pgsql function which wraps your argument table,
> builds the query, and invokes the query with EXECUTE.
For an example see slide 19 here:
http://www.joeconway.com/presentations/LISA2012-PredSrvAnalytics.pdf
> beware sql injection.
good point!
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Groshev Andrey | 2012-12-18 17:34:53 | Re: [GENERAL] trouble with pg_upgrade 9.0 -> 9.1 |
| Previous Message | Merlin Moncure | 2012-12-18 16:50:49 | Re: evaluating expressions stored in table |