Hello Iam play with SRF function and found difference between behavior system function pg_stat_get_backend_idset and own function in plpgsql;
aopk=> \df pg_stat_get_backend_idset Datový typ výsledku | Schéma | Jméno | Datový typ parametru ---------------------+------------+---------------------------+---------------------- setof integer | pg_catalog | pg_stat_get_backend_idset | aopk=> \df aa Datový typ výsledku | Schéma | Jméno | Datový typ parametru ---------------------+--------+-------+---------------------- setof integer | public | aa | (1 řádka) I can select * from pg_stat_get_backend_idset(); I can select * from aa() I understand, but I can call too select pg_stat_get_backend_idset(); pg_stat_get_backend_idset --------------------------- 1 2 (2 řádek) This isn't right for srf function, or else. I wont write own srf function with equal feature - similir like MSSQL procedures. It's possible? Regards Pavel ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match