Thread

pl/pgsql documentation

PostgreSQL Bugs List <pgsql-bugs@postgresql.org> — 2001-01-26T00:17:23Z

Darcy (Darcy@ok-connect.com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
pl/pgsql documentation

Long Description
The following documentation does not apear to reflect real world use.

[<<label>>]
FOR record | row IN select_clause LOOP
    statements
END LOOP;

(as snipped from http://postgresql.readysetnet.com/users-lounge/docs/7.0/postgres/c40914117.htm)

Sample Code
CREATE TABLE major_groups(id SERIAL, name TEXT);
INSERT INTO major_groups(name) VALUES 'one';
INSERT INTO major_groups(name) VALUES 'two';
INSERT INTO major_groups(name) VALUES 'three';

CREATE FUNCTION test3(INT4) RETURNS INT4 AS '
  DECLARE
    loc  INT4;
  BEGIN
    loc := $1;
    for i IN (select id from major_groups) loop
      (
      loc := $loc + $i;
      )
    end loop;
    return $loc;
  end;
' language 'plpgsql';

select test3(2);

NOTICE:  plpgsql: ERROR during compile of test3 near line 10
ERROR:  parse error at or near ";"


No file was uploaded with this report