Michael Fuhr wrote:
On Fri, Aug 04, 2006 at 06:44:16PM +0300, gustavo halperin wrote:
Michael Fuhr wrote:
Since the function has OUT parameters you can use "RETURNS SETOF record"
like this:
CREATE FUNCTION funcname(<params>) RETURNS SETOF record AS $$
<body>
$$ LANGUAGE SQL
What do you mean with the word "record", can you give an example of how
this "record" looks for two columns ?
"record" means the literal word "record". Example:
CREATE FUNCTION show_tables(OUT schema_name text, OUT table_name text)
RETURNS SETOF record AS $$
SELECT table_schema, table_name
FROM information_schema.tables;
$$ LANGUAGE sql;
SELECT * FROM show_tables()
Thank you, IS WORK, Thank you very much for your help.
Gustavo
