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();
--
Michael Fuhr