Re: ECPG problem with 8.3

----- Original Message ----
> From: Peter Wilson <petew@yellowhawk.co.uk>
> To: Michael Meskes <meskes@postgresql.org>; pgsql-general@postgresql.org
> Sent: Monday, January 14, 2008 8:41:12 AM
> Subject: Re: [GENERAL] ECPG problem with 8.3
>
> Fetch with a variable seems to be almost the only useful way of
> using
>
 FETCH
> ABSOLUTE (or any of the variants that have count parameter).
>
> For backwards compatibility wouldn't it be better to do the sprintf
> in
>
 the ECPG
> preprocessor if the count is a variable rather than generate an
> error?

I'd like to add to this discussion from an Oracle Pro*C (Oracle's name for embedded SQL) perspective.  Most of the
Pro*Ccode that I've worked with over the years uses a variable for the fetch count as well.  It'd be nice if there was
someway to support this convention directly in ECPG (assuming it doesn't create maintenance/security issues) for anyone
portingapplications from Oracle to Postgresql. 

Regards,

Shelby Cain




      ____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ