Re: dynamic sql in ecpg

Adolfo Verón wrote:

> Dear Christof,
> 
> I've developed an informix-interface which is based on ANSI dynamic sql
> using esql/c.  Now I want to port that code to postgreSQL-ecpg and the
> question is:
> 
> does ecpg support ANSI dynamic sql ?  I've found problems with
> statements like this:
> 
> EXEC SQL allocate descriptor
> EXEC SQL describe ... using sql descriptor
> EXEC SQL execute ... into [descriptor]
> 
> I'm working on PostgreSQL 7.1.3 and ecpg 2.8.0.
> May I use PostgreSQL 7.2 which is in beta version?
> 
> Your answer will be highly appreciated.
> Thanks in advance.
> 
> Adolfo Verón.
> MCAnet S.A.
> 
> 
> 

Please do not waste your time trying to use 7.1. A lot of dynamic sql 
fixes went into 7.2 and if you still have any troubles please report 
them (to me).

What will not work is:

using descriptor + set descriptor. This is simply not implemented at all.

You might use something similar to what do: a 7.1 database and 7.2s 
ecpg/libecpg. Though if you do not have to maintain an existing database 
you should use 7.2 for all.
  Christof