Return Multiple Rows from Store Function

[Brahmam Eswar]

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.