-- -- faq__name/1 -- create or replace function faq__name( p_faq_id integer ) returns varchar as $$ DECLARE v_faq_name faqs.faq_name%TYPE; BEGIN select faq_name into v_faq_name from faqs where faq_id = p_faq_id; return v_faq_name; END; $$ language plpgsql;