SQL statements in SQL/PSM samples
Verze z 3. 12. 2006, 20:29, kterou vytvořil 85.160.108.43 (diskuse)
SQL support
CREATE OR REPLACE FUNCTION fx(OUT a int) AS $$ SELECT INTO a sum(y) FROM foo; $$ LANGUAGE plpgpsm; CREATE OR REPLACE FUNCTION fx() RETURNS int AS $$ BEGIN DECLARE i int DEFAULT 0; WHILE i < 10 DO INSERT INTO foo VALUES(i, i+1); SET i = i + 1; END WHILE; RETURN i; END; $$ LANGUAGE plpgpsm;