Re: Dynamic SQL

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