Обсуждение: How to return SETOF RECORD?

Hello,

i'm writting some functions for parsing urls and handling strings. But i
have problems with the result set.

I already figured out how to return a single record/row. But i need
more. A good example for what i want is ts_debug();

cse=> SELECT alias, token from
ts_debug('http://www.postgresql.org/docs/index.html');
   alias   |               token
----------+------------------------------------
  protocol | http://
  url      | www.postgresql.org/docs/index.html
  host     | www.postgresql.org
  url_path | /docs/index.html


I try to get an output like that:
cse=> SELECT alias, token from
parse_uri('http://www.postgresql.org/docs/index.html');
   alias   |               token
----------+------------------------------------
  scheme   | http://
  url      | www.postgresql.org/docs/index.html
  host     | www.postgresql.org
  path     | /docs/
  file     | index.html

But i never get more than one row return. I need a hint how i can return
more than one row. Or even better: a littel example ;)

Thanks very much and greetings from Germany,
Torsten

Hello

http://www.postgres.cz/index.php/PL/pgSQL_(en)#Functions_which_return_tables

regards
Pavel Stehule

2009/5/4 Torsten Zühlsdorff <foo@meisterderspiele.de>:
> Hello,
>
> i'm writting some functions for parsing urls and handling strings. But i
> have problems with the result set.
>
> I already figured out how to return a single record/row. But i need more. A
> good example for what i want is ts_debug();
>
> cse=> SELECT alias, token from
> ts_debug('http://www.postgresql.org/docs/index.html');
>  alias   |               token
> ----------+------------------------------------
>  protocol | http://
>  url      | www.postgresql.org/docs/index.html
>  host     | www.postgresql.org
>  url_path | /docs/index.html
>
>
> I try to get an output like that:
> cse=> SELECT alias, token from
> parse_uri('http://www.postgresql.org/docs/index.html');
>  alias   |               token
> ----------+------------------------------------
>  scheme   | http://
>  url      | www.postgresql.org/docs/index.html
>  host     | www.postgresql.org
>  path     | /docs/
>  file     | index.html
>
> But i never get more than one row return. I need a hint how i can return
> more than one row. Or even better: a littel example ;)
>
> Thanks very much and greetings from Germany,
> Torsten
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>