Re: [GENERAL] Select from function for part of column results
Hi Oisin On 03/02/05, Oisin Glynn ([EMAIL PROTECTED]) wrote: > I have something simlar working on windows in V 8.0 > My select loks like: > > SELECT *,function_message_context(inbox.rowid) from inbox; This works great for a function returning a single column. I'm not sure how to do it with a function returning more than one column. st4=> select *, fn_message_context(n_id) from inbox; ERROR: cannot display a value of type record Rory > - Original Message - > From: "Rory Campbell-Lange" <[EMAIL PROTECTED]> > To: "Postgresql General List" > Sent: Thursday, February 03, 2005 15:04 > Subject: [GENERAL] 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? -- Rory Campbell-Lange <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [GENERAL] Select from function for part of column results
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" <[EMAIL PROTECTED]> To: "Postgresql General List" Sent: Thursday, February 03, 2005 15:04 Subject: [GENERAL] 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 > <[EMAIL PROTECTED]> > > > ---(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 [EMAIL PROTECTED]
[GENERAL] 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 <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
