Hi,
I have been playing around with 8.1(it's very nice by the way) and was
trying to get OUT params to return more than 1 row.

I came up with the function below, and it does work, however I had to
declare another record to use in the FOR ..IN loop.

From my reading of the docs the out params create a record type
automaticly and my question is how can I use this automaticly created
record in the
FOR loop? It does not seem right that I have to create another record
type and then copy the row values to the out parms.

CREATE OR REPLACE FUNCTION test_func9(out firstname varchar, out
lastname varchar)
RETURNS SETOF record AS
$BODY$
Declare
row record;
BEGIN
for row in select null,description from common.common_groups
loop
firstname = row.description;
lastname = '';
RETURN NEXT;
end loop;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;

Thanks,

Tony

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

On Wed, Aug 31, 2005 at 11:27:39AM -0500, Tony Caduto wrote:

Hi,

> I came up with the function below, and it does work, however I had to
> declare another record to use in the FOR ..IN loop.
>
> From my reading of the docs the out params create a record type
> automaticly and my question is how can I use this automaticly created
> record in the FOR loop? It does not seem right that I have to create
> another record type and then copy the row values to the out parms.

The record that you are not supposed to declare is the output record,
i.e. you don't have to use CREATE TYPE, use a table type, or describe
the anonymous record in the SELECT statement. Of course, in PL/pgSQL
you need a variable to do the FOR ... LOOP.

Your example works fine for me. What exactly were you expecting?

--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
"Escucha y olvidarás; ve y recordarás; haz y entenderás" (Confucio)

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq