Re: 7.3beta and ecpg

On Wed, Sep 11, 2002 at 03:42:44PM +0200, Zeugswetter Andreas SB SD wrote:
> That is how I understood it so far.

I will dig into this as soon as I find time, i.e. definitely for 7.3.

> > Actually ecpg needs 'execute id using ... into ...'. I did not see any
> > mention of using in the backend execute command. The 'execute :idvar'
> > part is easier since this correctly is named 'execute immediate :idvar'
> > I think.
> 
> The "using" clause is optional, I just left it out. My ESQL/C precompiler

Correct, "using" is optional with ecpg as well.

> can also use an id variable for "execute :idvar using ...". That is actually 
> how we use esql/c here.    

And how we used Pro*C when I was still working with Oracle.

> > AFAIK the standard is "execute ID using value" and not "execute
> > ID(value)". Please correct me if I'm wrong, but right now ecpg uses the
> > first syntax the backend uses the second.
> 
> I think it should be the intention to keep those identical, which would
> mean, that the backend syntax is currently wrong :-(

Which of course means we should change it. :-)

Michael
-- 
Michael Meskes
Michael@Fam-Meskes.De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!