Michael Meskes írta:
> On Sat, Aug 08, 2009 at 04:57:57PM -0400, Tom Lane wrote:
>
>> The fundamental reason that there's a problem here is that ecpg has
>> decided to accept a syntax that the backend doesn't (ie, FETCH with a
>> fetch direction but no FROM/IN). I think that that's basically a bad
>>
>
> Which was added because most if not all other precompilers allow this syntax
> and of course it didn't do any harm until now.
>
:-( Why me? ;-)
>> idea: it's not helpful to users to be inconsistent, and it requires ugly
>> hacks in ecpg, and now ugly hacks in the core grammar as well. We
>> should resolve it either by taking out that syntax from ecpg, or by
>> making the backend accept it too. Not by uglifying the grammars some
>> more in order to keep them inconsistent.
>>
>
> Couldn't agree more.
>
> I'd like to figure out exactly what syntax other DBMSes accept. It appears
> Informix allows the cursor name as a variable but has neither FORWARD/BACKWARD
> nor FROM/IN. Zoltan, could you please check whether my docs are right?
>
Yes, your docs seems to be right. From my docs, Informix allows these:
FETCH { [NEXT] | PRIOR | PREVIOUS | FIRST | LAST | CURRENT | ABSOLUTE pos_var_or_const | RELATIVE {
[+]pos_var_or_const| -pos_const } } { cursor_id | cursor_var } { USING [SQL] DESCRIPTOR ... | INTO
host_var_list...}
There's no FROM or IN anywhere in the syntax snake maze graph.
> A quick google search seems to suggest that the same holds for Oracle that
> apparently allows less options.
>
> Michael
>
Best regards,
Zoltán Böszörményi
--
Bible has answers for everything. Proof:
"But let your communication be, Yea, yea; Nay, nay: for whatsoever is more
than these cometh of evil." (Matthew 5:37) - basics of digital technology.
"May your kingdom come" - superficial description of plate tectonics
----------------------------------
Zoltán Böszörményi
Cybertec Schönig & Schönig GmbH
http://www.postgresql.at/
