Re: Calling SQL functions that return sets

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Chris Mungall <cjm(at)fruitfly(dot)org>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Calling SQL functions that return sets
Date: 2005-08-01 23:57:17
Message-ID: 26174.1122940637@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Chris Mungall <cjm(at)fruitfly(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Chris Mungall 2005-08-02 01:14:22 Re: Calling SQL functions that return sets
Previous Message Chris Mungall 2005-08-01 21:43:52 Calling SQL functions that return sets