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
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
