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
Re: PostgreSQL equivalent to Oracles ANYDATASET
Список 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 по дате отправления: