| From: | John Sidney-Woollett <johnsw(at)wardbrook(dot)com> |
|---|---|
| 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:33:30 |
| Message-ID: | 41FE259A.3090406@wardbrook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Yes, it does. And it's a lot easier than DBMS_SQL too!
Look at the EXECUTE command in the pl/pgsql programming language.
See http://www.postgresql.org/docs/7.4/interactive/plpgsql-statements.html
John Sidney-Woollett
Mark Battersby wrote:
> Hi
>
>
>
> 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.
>
>
>
> Any tips appreciated.
>
>
>
> /Mark
>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2005-01-31 12:37:01 | Re: Dynamic SQL |
| Previous Message | Rich Doughty | 2005-01-31 12:26:09 | Increasing the length of a varchar domain |