Re: Dynamic SQL

From: Troels Arvin <troels(at)arvin(dot)dk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Dynamic SQL
Date: 2005-01-31 12:48:35
Message-ID: pan.2005.01.31.12.48.34.596277@arvin.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

  • Dynamic SQL at 2005-01-31 12:18:38 from Mark Battersby

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2005-01-31 13:18:34 Re: Extended unit
Previous Message Shridhar Daithankar 2005-01-31 12:37:01 Re: Dynamic SQL