title: Join multiple tables as a return in PostgreSQL function
body: <p>Is it possible to &quot;not express&quot; return type of a function that return a select of a joined tables because a have a lot of columns and i don't want to write them manually
  Myfunction looks like this:</p>
  <pre><code>CREATE or REPLACE FUNCTION selectJoin()
  RETURNS SETOF ???
  AS $$
  BEGIN
      RETURN QUERY SELECT t1.*, t2.*
                   FROM t1, t2
                   WHERE t1.t2_id = t2.id;
  END; $$
  LANGUAGE plpgsql
  </code></pre>