Re: Select from function for part of column results

Hi Oisin

On 03/02/05, Oisin Glynn (me(at)oisinglynn(dot)com) 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" <rory(at)campbell-lange(dot)net>
> To: "Postgresql General List" <pgsql-general(at)postgresql(dot)org>
> 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
<rory(at)campbell-lange(dot)net>
<www.campbell-lange.net>