http://postgres.cz/api.php?action=feedcontributions&user=85.160.108.202&feedformat=atom
PostgreSQL - Příspěvky [cs]
2024-03-29T15:17:31Z
Příspěvky
MediaWiki 1.36.0
http://postgres.cz/index.php?title=Dynamic_SQL_in_SQL/PSM_samples&diff=217
Dynamic SQL in SQL/PSM samples
2007-01-17T19:56:47Z
<p>85.160.108.202: /* PREPARE/EXECUTE INTO USING */</p>
<hr />
<div>=== EXECUTE IMMEDIATE INTO ===<br />
<pre><br />
CREATE OR REPLACE FUNCTION fx() <br />
RETURNS int AS <br />
$$<br />
BEGIN <br />
DECLARE a,b int; <br />
EXECUTE IMMEDIATE 'SELECT 10,20' INTO a,b; <br />
PRINT a,b; <br />
RETURN a+b; <br />
END; <br />
$$ LANGUAGE plpgpsm;<br />
</pre><br />
<br />
=== PREPARE/EXECUTE INTO USING ===<br />
<pre><br />
CREATE OR REPLACE FUNCTION fxx(a int)<br />
RETURNS float AS <br />
$$<br />
BEGIN<br />
DECLARE f float;<br />
PREPARE prep(float) from 'select $1';<br />
EXECUTE prep INTO f USING a; <br />
RETURN f ;<br />
END;<br />
$$ LANGUAGE plpgpsm;<br />
</pre></div>
85.160.108.202