Hi ,
Returning multiple rows from store functions using "RETURNS TABLE" and
RETURN QUERY. The results set may have more than 50k records. Does it give
any performance issues related to memory? if yes how to avoid it
CREATE OR REPLACE FUNCTION funcq(COL1 character varying)
)
RETURNS TABLE
( a VARCHAR,
b VARCHAR,
c varchar)
AS $$
BEGIN
RETURN QUERY SELECT a,b,c from table1 where C= COL1;
END;
$$
LANGUAGE plpgsql;
--
Thanks & Regards,
Brahmeswara Rao J.