Re: Create function problem

Michael Fuhr <mike@xxxxxxxx> · Fri, 4 Aug 2006 10:23:19 -0600

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