why I can call pg_stat_get_backend_idset directly - Mailing list pgsql-general

From Pavel Stehule
Subject why I can call pg_stat_get_backend_idset directly
Date
Msg-id Pine.LNX.4.44.0401081830030.32257-100000@kix.fsv.cvut.cz
Whole thread Raw
List pgsql-general
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




pgsql-general by date:

Previous
From: Ben
Date:
Subject: Re: Simulation output using libpq
Next
From: Oleg Lebedev
Date:
Subject: deferring/disabling unique index