PL/PgSQL - returning multiple columns ... - Mailing list pgsql-sql

From Marc G. Fournier
Subject PL/PgSQL - returning multiple columns ...
Date
Msg-id 20050202170643.R27579@ganymede.hub.org
Whole thread Raw
List pgsql-sql
I have a function that I want to return 'server_name, avg(load_avg)' ... 
if I wanted to return matching rows in a table, I can do a 'setof 
<table>', with a for loop inside ... but what do I set the 'RETURNS' to if 
I want to return the results of query that returns only two fields of a 
table, or, in the case of the above, one column and oen 'group by' column?

thanks ...


----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664


pgsql-sql by date:

Previous
From: "Joel Fradkin"
Date:
Subject: Re: pg_restore problem
Next
From: Tom Lane
Date:
Subject: Re: pg_restore problem