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!