How to return SETOF RECORD?
От | Torsten Zühlsdorff |
---|---|
Тема | How to return SETOF RECORD? |
Дата | |
Msg-id | gtmdq0$fui$1@news.motzarella.org обсуждение исходный текст |
Ответы |
Re: How to return SETOF RECORD?
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: