Select from function for part of column results

Поиск
Список
Период
Сортировка
От Rory Campbell-Lange
Тема Select from function for part of column results
Дата
Msg-id 20050203200426.GA25752@campbell-lange.net
обсуждение исходный текст
Список pgsql-general
I've written a function to provide information relating to each row in
an inbox. I'd like to do a query returning some information from each
row of the inbox + some columns from the function pertinent to each row
returned.

I've tried the following on 7.4.6:

    t4=> select * from function_message_context(inbox.rowid), inbox;
    ERROR:  function expression in FROM may not refer to other
            relations of same query level

Is there a way I can get the function to provide some columns in the
query?

Thanks
Rory

--
Rory Campbell-Lange
<rory@campbell-lange.net>
<www.campbell-lange.net>

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

Предыдущее
От: Martin Balint
Дата:
Сообщение: Re: Hiding databases
Следующее
От: "Oisin Glynn"
Дата:
Сообщение: Re: Select from function for part of column results