-- -- person__name/1 -- create or replace function person__name( integer ) returns varchar as $$ declare name__person_id alias for $1; begin return first_names || ' ' || last_name from persons where person_id = name__person_id; end;$$ language plpgsql;