Postgres Pro
Downloads
Home   >   mailing lists

How do you return more than one variable in a plpgsql function? - Mailing list pgsql-sql

From Mark Nielsen
Subject How do you return more than one variable in a plpgsql function?
Date
Msg-id 3C62E6FC.1040208@kepnet.net
Whole thread Raw
Responses Re: How do you return more than one variable in a plpgsql function?  (Vincent AE Scott <pgsql-sql@codex.net>)
List pgsql-sql
Tree view 
I have never figured out how to make a plpgsql function return more than 
one variable or type. I read something where a function an return an 
open cursor, but I never figured out how. I want a function to be able 
to return an entire row of a table or a number of fields from different 
tables using plpgsql.

How can I do that?
Thanks!
Mark

pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: ALTER TABLE and dropping a column
Next
From: Mark Nielsen
Date:
Subject: Re: Looking for the correct solution for a generic problem.