Re: [SQL] Calling SQL functions that return sets

Chris Mungall <[EMAIL PROTECTED]> writes: > On Mon, 1 Aug 2005, Tom Lane wrote: >> Chris Mungall <[EMAIL PROTECTED]> 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 >> targe

Re: [SQL] Calling SQL functions that return sets

On Mon, 1 Aug 2005, Tom Lane wrote: > Chris Mungall <[EMAIL PROTECTED]> 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, w

Re: [SQL] Calling SQL functions that return sets

Chris Mungall <[EMAIL PROTECTED]> 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 not

[SQL] Calling SQL functions that return sets

Hi all, I have a question on functions returning sets. I have a lot of complex functionality I would like to keep in the DBMS rather than in an application, and I would like this functionality to be available as queries over standard SQL relations. Section 31.4.4 of the docs (http://www.postgres