create or replace function my_trans(IN inid character)
RETURNS TABLE(
  a_date timestamp without time zone,
  pnt_sys character,
  nval numeric,
  pnt_type character,
  gpid integer)
as $$
#variable_conflict use_column
BEGIN
    RETURN QUERY
    SELECT
             BORN_DATE,
             MY_SYSTEM,
             MY_VALUE,
             MY_TYPE,
             MY_PAY_ID
     FROM vw_psr where nid ~* '$1';
end;
$$ language plpgsql

create or replace function my_trans(p_inid text)
RETURNS TABLE(
  a_date timestamp without time zone,
  pnt_sys character,
  nval numeric,
  pnt_type character,
  gpid integer)
as $$
    SELECT BORN_DATE,
           MY_SYSTEM,
           MY_VALUE,
           MY_TYPE,
           MY_PAY_ID
    FROM vw_psr
    where nid ~* p_inid;
$$ language sql;