| From: | Shridhar Daithankar <ghodechhap(at)ghodechhap(dot)net> |
|---|---|
| To: | Mark Battersby <mark(dot)battersby(at)cvision(dot)cn> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Dynamic SQL |
| Date: | 2005-01-31 12:37:01 |
| Message-ID: | 41FE266D.10809@ghodechhap.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Mark Battersby wrote:
> When looking at PostGres through the eyes of an Oracle Developer I was
> wondering if PostGres supports a feature called Dynamic SQL. Of course
> even better would be the ability to run PostGress/PL dynamically too.
>
> Dynamic SQL and Dynamic PL/SQL are useful when you don’t know until
> runtime how your SQL or PL/SQL looks like.
Does this help?
http://www.postgresql.org/docs/8.0/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
http://www.postgresql.org/docs/8.0/static/plpgsql-porting.html
http://www.postgresql.org/docs/8.0/static/ecpg-dynamic.html
http://www.postgresql.org/docs/8.0/static/libpq-exec.html
Shridhar
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Troels Arvin | 2005-01-31 12:48:35 | Re: Dynamic SQL |
| Previous Message | John Sidney-Woollett | 2005-01-31 12:33:30 | Re: Dynamic SQL |