🚀 go-pugleaf

> IIRC there's an undocumented WHERE CURSOR OF feature in the stored
> procedure and trigger language, but it isn't actually useful for
> anything.

Actually, it's quite useful and fairly easy to use.

Here's an example:

CREATE PROCEDURE LOOP_NAMED_FOR
AS
declare variable v_value integer;
begin
  for select v
        from dummy_rows_10
        into :v_value
        as cursor mycursor
  do begin
       update dummy_rows_10
          set v = :v_value
        where current of mycursor;
     end
end

As you can see, it allows for easier updating of values in the
table that's being used in the "named for loop". This way, you
can even update tables without a primary key or without selecting
the primary key value.

This was a small example in my "Stored Procedures and Triggers in Depth"
presentation which covered Firebird PSQL, but this is also available
in InterBase.


-- 
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com