Help with function

From: "Chris Hoover" <revoohc(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Help with function
Date: 2006-10-03 20:49:02
Message-ID: 1d219a6f0610031349v78802955ye8316d29d49f0f34@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I need some help with writing a plpgsql function. I want to return multiple
items from the function. How do I do this?

Here is my attempt at the function (note, this is a simple example that
could obviously be done via a view, but I am trying to learn more about
writing plpgsql functions):

create or replace function dba.active_transactions_by_db() returns setof
integer pg_stat_activity.datname%TYPE as
$BODY$
declare
dbName varchar;
activeTransactions integer;
countRec record;
begin
for countRec in select count(1) as cnt, datname from pg_stat_activity
group by datname loop
return next countRec;
end loop;

return countRec;
end;
$BODY$
language plpgsql;

Responses

Browse pgsql-general by date

  From Date Subject
Next Message stevegy 2006-10-03 23:50:12 Re: &nbsp;&nbsp;Hi,&nbsp;ever
Previous Message Erik Jones 2006-10-03 20:26:28 Re: Need help with a function from hell..