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