Ingres 11.2 | RETURN ROW Example

SQL Reference Guide > SQL Reference Guide > SQL Statements > RETURN ROW > RETURN ROW Example

Was this helpful?

RETURN ROW Example

The following is a RETURN ROW example:

CREATE PROCEDURE rowproc ... AS
    ... RESULT ROW (CHAR(8), INT, FLOAT) ...
BEGIN
    ...
    FOR SELECT department, COUNT(*), AVG(salary) INTO :a, :b, :c FROM personnel
        GROUP BY deptname DO
    ...
   RETURN ROW (:a, :b, :c);
    ENDFOR;
     ...
  END;

Last modified date: 08/28/2024