> > AFAIK some SQL/C type precompilers and other frontend tools for other
> > databases do generate stored procedures for PREPAREd CURSORs.
>
> You mean ECPG should/could replace a PEPARE statement with a CREATE
> FUNCTION and then the usage of the cursor with the usage of that
> function?
>
> Should be possible, but needs some work.
Wow Michael, this would be much much much appreciated. :-)
> > I'm afraid ECPG does not :(
>
> That's correct of course.
> Michael
Thanks. Then we know our conclusions on the survey are right.
We hope functionality about prepared cursors, bind variables, etc will
come soon in PG :-)
We actually think about solutions to patch PostgreSQL and contribute
this way, adding a feature we need for business.
Thanks.
--
Jean-Paul ARGUDO IDEALX S.A.S
Consultant bases de données 15-17, av. de Ségur
http://www.idealx.com F-75007 PARIS