PostgreSQL equivalent to Oracles ANYDATASET

Поиск
Список
Период
Сортировка
От Dirk Mika
Тема PostgreSQL equivalent to Oracles ANYDATASET
Дата
Msg-id 198CEF8B-3DD8-4396-A6AF-E0D2E3567FBB@mikatiming.de
обсуждение исходный текст
Ответы Re: PostgreSQL equivalent to Oracles ANYDATASET  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: PostgreSQL equivalent to Oracles ANYDATASET  (Christoph Moench-Tegeder <cmt@burggraben.net>)
Список 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

--
Dirk Mika
Software Developer



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

fon +49 2202 2401-1197
dirk.mika@mikatiming.de
www.mikatiming.de

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


 
Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Problem with psprintf and intmax_t (%jd)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Issue upgrading from 9.5 to 13 with pg_upgrade: "connection to database failed: FATAL: database "template1" does not exist"