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
>