Re: [PERFORM] Dynamic sql example
2009/11/24 ramasubramanian : > Dear All. > Can any one give me dynamic sql in postgres stored procedure using > "USING CLAUSE" CREATE TABLE tab(a integer); CREATE OR REPLACE FUNCTION foo(_a integer) RETURNS void AS $$ DECLARE r record; BEGIN FOR r IN EXECUTE 'SELECT * FROM tab WHERE a = $1'
[PERFORM] Dynamic sql example
Dear All. Can any one give me dynamic sql in postgres stored procedure using "USING CLAUSE" Regards, Ram