Hello http://www.postgres.cz/index.php/PL/pgSQL_(en)#Functions_which_return_tables regards Pavel Stehule 2009/5/4 Torsten Zühlsdorff <foo@xxxxxxxxxxxxxxxxxxx>: > 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
