I have something simlar working on windows in V 8.0 My select loks like: SELECT *,function_message_context(inbox.rowid) from inbox; Hope this helps. Oisin ----- Original Message ----- From: "Rory Campbell-Lange" <rory@xxxxxxxxxxxxxxxxxx> To: "Postgresql General List" <pgsql-general@xxxxxxxxxxxxxx> Sent: Thursday, February 03, 2005 15:04 Subject: Select from function for part of column results > 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@xxxxxxxxxxxxxxxxxx> > <www.campbell-lange.net> > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
