Re: pgsql: Make the pg_stat_activity view call a SRF - Mailing list pgsql-committers

From Magnus Hagander
Subject Re: pgsql: Make the pg_stat_activity view call a SRF
Date
Msg-id 48A86B13.5080800@hagander.net
Whole thread Raw
In response to Re: pgsql: Make the pg_stat_activity view call a SRF  ("Jaime Casanova" <jcasanov@systemguards.com.ec>)
List pgsql-committers
Jaime Casanova wrote:
> On Sat, Aug 16, 2008 at 12:03 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> regression=# select * from pg_show_all_settings();
>> ERROR:  a column definition list is required for functions returning "record"
>>
>> There's no longer any very good reason for built-in SRFs to not define
>> their own output record type.
>>
>
> is there any one doing this? if not i want to give it a try... seems
> easy enough, even for me :)

It's on my list, but I haven't actually started it yet. So - take it away!

//Magnus

pgsql-committers by date:

Previous
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Remove prohibition against SubLinks in the WHERE clause of an
Next
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Add some defenses against constant-FALSE outer join conditions.