Search Postgresql Archives

PostgreSQL equivalent to Oracles ANYDATASET

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxx
www.mikatiming.de

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


 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux