Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

Next:From: Martijn van OosterhoutDate: 2005-01-31 13:18:34
Subject: Re: Extended unit
Previous:From: Shridhar DaithankarDate: 2005-01-31 12:37:01
Subject: Re: Dynamic SQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group