PostgreSQL equivalent to Oracles ANYDATASET - Mailing list pgsql-general

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