Re: Dynamic SQL - Mailing list pgsql-general

From Troels Arvin
Subject Re: Dynamic SQL
Date
Msg-id pan.2005.01.31.12.48.34.596277@arvin.dk
Whole thread Raw
In response to Dynamic SQL  ("Mark Battersby" <mark.battersby@cvision.cn>)
List pgsql-general
On Mon, 31 Jan 2005 13:18:38 +0100, 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.

PostgreSQL does not conform to the "Basic dynamic SQL" feature of the SQL
standard (feature ID B031). However, PostgreSQL supports some of the
involved concepts, like prepared statements. See
http://www.postgresql.org/docs/8.0/static/ecpg.html and in particular
http://www.postgresql.org/docs/8.0/static/ecpg-dynamic.html

--
Greetings from Troels Arvin, Copenhagen, Denmark


pgsql-general by date:

Previous
From: Shridhar Daithankar
Date:
Subject: Re: Dynamic SQL
Next
From: Ragnar Hafstað
Date:
Subject: Re: postgres session termination