Postgres Pro
Downloads
Home   >   mailing lists

Returning a table from a function, that requires multiple selects? - Mailing list pgsql-general

From stan
Subject Returning a table from a function, that requires multiple selects?
Date
Msg-id 20190830200315.GA28175@panix.com
Whole thread Raw
Responses Re: Returning a table from a function, that requires multipleselects?  (Guyren Howe <guyren@gmail.com>)
Re: Returning a table from a function, that requires multipleselects?  (Rob Sargent <robjsargent@gmail.com>)
Re: Returning a table from a function, that requires multipleselects?  (stan <stanb@panix.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Aggregate functions on groups [RESOLVED]
Next
From: Rob Sargent
Date:
Subject: Re: Returning a table from a function, that requires multipleselects?