Search Postgresql Archives
pl/pgsql FOR LOOP with function
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- To: "pgsql general" <pgsql-general@xxxxxxxxxxxxxx>
- Subject: pl/pgsql FOR LOOP with function
- From: "David Legault" <legault.david@xxxxxxxxx>
- Date: Sat, 10 Mar 2007 14:13:00 -0500
- Dkim-signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=Betsw4dp1MpAMx3uG3Uevdr341n6jz+uBzDR9CxQGHH/v0OHhlGDkUVFAUlsdFj5aHLcn4Oaj8+fkN5PCxYoiD7fUt6M2Lt6yEhJz7PhR8oHEjAorJ68HOvCPPzJ+D083T/RnIsP7b0zBof4j8J5sr/BuZNV8a/zkoeVmIs2vxU=
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
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]