Re: set returning function with variable argument - possible?

Поиск
Список
Период
Сортировка
От Frank Miles
Тема Re: set returning function with variable argument - possible?
Дата
Msg-id alpine.LRH.2.01.1106181349500.17307@homer03.u.washington.edu
обсуждение исходный текст
Ответ на Re: set returning function with variable argument - possible?  ("David Johnston" <polobo@yahoo.com>)
Список pgsql-general
On Thu, 16 Jun 2011, David Johnston wrote:

> The only way to feed another relation into a function is to place the
> function in the SELECT list.  If you then want to expand the result of the
> function call you alias the function result and then ".*" against it.
>
> WITH feeder AS (
> SELECT f(var) AS result FROM xtable WHERE ...
> )
> SELECT (feeder.result).*
> FROM feeder
> ;

[snip]

Thanks, David, this worked perfectly!  {thanks also to Pavel}

     -Frank

В списке pgsql-general по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: While converting the Master to Standby , FATAL: timeline 2 of the primary does not match recovery target timeline 1
Следующее
От: Daron Ryan
Дата:
Сообщение: Search for lists