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?  (Pavel Stehule <pavel.stehule@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Dan Armbrust
Дата:
Сообщение: Re: recover corrupt DB?
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: How to return SETOF RECORD?