> On Aug 30, 2019, at 2:03 PM, stan <st...@panix.com> wrote: > > I need to encapsulate, what are basically 2 related function calls into a > single > function. The result of each of th calls is a date type. > > y current thinking is to return a 2 row table with the 2 dates in it. But, I > seem to > be having issues getting this to work. > > Is it possible for a function to return a table with results from multiple > queries? > > -- > "They that would give up essential liberty for temporary safety deserve > neither liberty nor safety." > -- Benjamin Franklin > > If the two queries are identical in returned columns you might be able to use UNION: select f1.* from first_query as f1 UNION select f2.* from second_query as f2;
You can’t do any processing of f1 or f2.
