Select from function for part of column results

From: Rory Campbell-Lange <rory(at)campbell-lange(dot)net>
To: Postgresql General List <pgsql-general(at)postgresql(dot)org>
Subject: Select from function for part of column results
Date: 2005-02-03 20:04:26
Message-ID: 20050203200426.GA25752@campbell-lange.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)campbell-lange(dot)net>
<www.campbell-lange.net>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oisin Glynn 2005-02-03 20:25:34 Re: Select from function for part of column results
Previous Message Jan Wieck 2005-02-03 19:36:55 Re: pgpool 2.5b2 released