From: | Dirk Mika <Dirk(dot)Mika(at)mikatiming(dot)de> |
---|---|
To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: PostgreSQL equivalent to Oracles ANYDATASET |
Date: | 2020-11-14 14:22:38 |
Message-ID: | 22C0588C-B59D-477D-B30A-62C53F4F67F7@mikatiming.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
That looks promising. I'll take a closer look at that.
Regards
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
Von: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Datum: Freitag, 13. November 2020 um 18:05
An: Dirk Mika <Dirk(dot)Mika(at)mikatiming(dot)de>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Betreff: Re: PostgreSQL equivalent to Oracles ANYDATASET
Hi
pá 13. 11. 2020 v 17:57 odesílatel Dirk Mika <Dirk(dot)Mika(at)mikatiming(dot)de<mailto:Dirk(dot)Mika(at)mikatiming(dot)de>> napsal:
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?
Currently there is not this possibility
Theoretically you can use a function, that returns refcursor, and outside function you can read this cursor
http://okbob.blogspot.com/2008/08/using-cursors-for-generating-cross.html
Regards
Pavel
BR
Dirk
--
Dirk Mika
Software Developer
[cid:175c28eef6b1377a7f41]
mika:timing GmbH
Strundepark - Kürtener Str. 11b
51465 Bergisch Gladbach
Germany
fon +49 2202 2401-1197
dirk(dot)mika(at)mikatiming(dot)de<mailto:dirk(dot)mika(at)mikatiming(dot)de>
www.mikatiming.de<http://www.mikatiming.de>
AG Köln HRB 47509 * WEEE-Reg.-Nr. DE 90029884
Geschäftsführer: Harald Mika, Jörg Mika
[cid:175c28eef6d822336482]<https://www.facebook.com/mikatiming>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2020-11-14 18:11:29 | Re: Partitioning docs (was Re: Range partitioning and overlap) |
Previous Message | Dirk Mika | 2020-11-14 11:20:29 | Re: PostgreSQL equivalent to Oracles ANYDATASET |