[GENERAL] How to return SETOF RECORD?

[Torsten Zühlsdorff]

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