Subject ROWS_AFFECTED usage?
Author Bob Murdoch
I'm trying to create the following stored procedure on FB 1.5:

create procedure debug_change_driver_daily(old_driver_id integer,
new_driver_id integer, start_date date, end_date date) returns
(rows_changed integer) as begin
rows_changed = 0;
update
driver_daily
set
driver_id = :new_driver_id
where
driver_id = :old_driver_id and
del_date between :start_date and :end_date;

rows_changed = rows_affected;
suspend;
end

When compiling the procedure I receive an error of 'unknown column
"ROWS_AFFECTED"'. My understanding is that this value is available in
PSQL?

tia,

Bob M..