http://postgres.cz/index.php?action=history&feed=atom&title=Dynamic_cursors_support_samples
Dynamic cursors support samples - Historie editací
2026-05-30T20:26:00Z
Historie editací této stránky
MediaWiki 1.43.3
http://postgres.cz/index.php?title=Dynamic_cursors_support_samples&diff=237&oldid=prev
85.160.101.251 v 12. 2. 2007, 11:50
2007-02-12T11:50:35Z
<p></p>
<p><b>Nová stránka</b></p><div><pre><br />
CREATE OR REPLACE FUNCTION fx(a int) <br />
RETURNS int AS <br />
$$ <br />
BEGIN <br />
DECLARE x, y integer; <br />
DECLARE SQLSTATE char(5); <br />
<br />
DECLARE cx CURSOR FOR prepstmt; <br />
<br />
PREPARE prepstmt(int) FROM 'SELECT a*100, b*100 FROM Foo WHERE Foo.a = $1'; <br />
<br />
OPEN cx USING a; <br />
<br />
FETCH cx INTO x, y; <br />
WHILE SQLSTATE = '00000' DO <br />
PRINT x, y; <br />
FETCH cx INTO x, y; <br />
END WHILE; <br />
<br />
CLOSE cx; <br />
RETURN a; <br />
END; <br />
$$ LANGUAGE plpgpsm; <br />
</pre></div>
85.160.101.251