-- -- template_demo_note__name/1 -- create or replace function template_demo_note__name( integer ) returns varchar as $$ declare p_template_demo_note_id alias for $1; v_template_demo_note_name template_demo_notes.title%TYPE; begin select title into v_template_demo_note_name from template_demo_notes where template_demo_note_id = p_template_demo_note_id; return v_template_demo_note_name; end; $$ language plpgsql;