Search Postgresql Archives

How to return SETOF RECORD?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux