Hello, we’re currently using Oracle and have a few functions in some packages, which are defined e.g. as follows:
FUNCTION get_results(p_id_series
series.id_series%TYPE)
RETURN ANYDATASET
PIPELINED USING t_series_get_results; It can be called like: SELECT
*
FROM
TABLE(series_pkg.get_results(1)); The purpose of this function is to provide a DATASET, which has different columns in the result depending on the passed parameter. Is there any way to achieve something similar in PostreSQL? BR Dirk
|