Dynamic SQL in SQL/PSM samples

2007-01-17T19:56:47Z

85.160.108.202: /* PREPARE/EXECUTE INTO USING */

=== EXECUTE IMMEDIATE INTO ===
<pre>
CREATE OR REPLACE FUNCTION fx()
RETURNS int AS
$$
BEGIN
DECLARE a,b int;
EXECUTE IMMEDIATE 'SELECT 10,20' INTO a,b;
PRINT a,b;
RETURN a+b;
END;
$$ LANGUAGE plpgpsm;
</pre>

=== PREPARE/EXECUTE INTO USING ===
<pre>
CREATE OR REPLACE FUNCTION fxx(a int)
RETURNS float AS
$$
BEGIN
DECLARE f float;
PREPARE prep(float) from 'select $1';
EXECUTE prep INTO f USING a;
RETURN f ;
END;
$$ LANGUAGE plpgpsm;
</pre>

PostgreSQL - Příspěvky [cs]

Dynamic SQL in SQL/PSM samples