Select from function for part of column results - Mailing list pgsql-general

From Rory Campbell-Lange
Subject Select from function for part of column results
Date
Msg-id 20050203200426.GA25752@campbell-lange.net
Whole thread Raw
List 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 by date:

Previous
From: Martin Balint
Date:
Subject: Re: Hiding databases
Next
From: "Oisin Glynn"
Date:
Subject: Re: Select from function for part of column results