pl/pgsql FOR LOOP with function - Mailing list pgsql-general

From David Legault
Subject pl/pgsql FOR LOOP with function
Date
Msg-id e0b20d410703101113s6993205eo97ccb8b2fe05285b@mail.gmail.com
Whole thread Raw
List pgsql-general
Hello,

How can I return the contents of the row object without knowing the names of the parameters in it ? I'd like to do something like row[1] or something similar. Or is there a way to actually get the values knowing the return type but not the name?

FOR row IN SELECT * FROM getgroups(usr) LOOP
   
        .. snip ..

END LOOP;

when

FUNCTION getgroups(usr name) RETURNS SETOF name AS

Thanks

David

pgsql-general by date:

Previous
From: "David Legault"
Date:
Subject: Re: HIPPA (was Re: Anyone know ...)
Next
From: "CAJ CAJ"
Date:
Subject: Upgrading Postgres large databases with blobs