Re: [Firebird-devel] A wish for cursors

[Martijn T. <m.t...@up...>]

One potential problem for implementing:

Firebird stores compiled (byte)code for stored procedures.

--
Martijn


Martijn Tonies wrote: 
  
Now this is my dream solution:

create procedure MyProc as
~~declare c cursor;
begin
~~for select field_a, field_b, field_c form my_table into
:c do begin
~~~~/* some processing */
~~~~c.field_a = c.field_b || c.field_c;
~~~~update my_table2 set field_a = c.field_a;
~~end
end
    

"c" isn't a cursor - it's a row. Oracle has a special construct
for this, something along the lines of:

declare r my_table%row;

Which defines variable "r" as to hold all columns in table
"my_table".
  
... postgresql has it too!