PostgreSQL equivalent to Oracles ANYDATASET

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
--
Dirk Mika
Software Developer

[cid:mt_c1c59b3d-dd43-4ca6-992b-79f5a19f5999.png]

mika:timing GmbH
Strundepark - Kürtener Str. 11b
51465 Bergisch Gladbach
Germany

fon +49 2202 2401-1197
dirk(dot)mika(at)mikatiming(dot)de
www.mikatiming.de

AG Köln HRB 47509 * WEEE-Reg.-Nr. DE 90029884
Geschäftsführer: Harald Mika, Jörg Mika

[cid:sig_ineos_2940640b-c572-4bba-865f-9f3ba3fea686.png]<https://www.facebook.com/mikatiming>