Postgres Pro
Downloads
Home   >   mailing lists

Re: Calling SQL functions that return sets - Mailing list pgsql-sql

From Tom Lane
Subject Re: Calling SQL functions that return sets
Date
Msg-id 26174.1122940637@sss.pgh.pa.us
Whole thread Raw
In response to Calling SQL functions that return sets  (Chris Mungall <cjm@fruitfly.org>)
Responses Re: Calling SQL functions that return sets  (Chris Mungall <cjm@fruitfly.org>)
List pgsql-sql
Tree view 
Chris Mungall <cjm@fruitfly.org> writes:
> What are the reasons for deprecating the use of the function in the
> SELECT clause?

The semantics of having more than one set-returning function in the
target list are, um, poorly thought out.  However, we haven't removed
the feature because (as you note) there are things you can't do any
other way.
        regards, tom lane

pgsql-sql by date:

Previous
From: Chris Mungall
Date:
Subject: Calling SQL functions that return sets
Next
From: Chris Mungall
Date:
Subject: Re: Calling SQL functions that return sets