Re: bug 1201 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: bug 1201
Date
Msg-id 6324.1098288500@sss.pgh.pa.us
Whole thread Raw
In response to Re: bug 1201  (Kris Jurka <books@ejurka.com>)
List pgsql-bugs
Kris Jurka <books@ejurka.com> writes:
> On Tue, 19 Oct 2004, Alvaro Herrera wrote:
>> Huh, shouldn't the user rather do
>> SELECT func_returning_void();

> The problem is that the function may actually be a SRF so the JDBC driver
> transforms to the "SELECT * FROM" form.

It's not really any weirder to allow this than to allow "SELECT func()",
as far as I can see.  Either way, you end up with a tuple containing one
column of type "void".  If we had a CALL statement then there might be
a reasonable argument for disallowing void-returning functions in both
places, but for now I've applied a modified form of Kris' patch.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Gottlieb Herbert"
Date:
Subject: ODBC 7.05. from PostgreSQL 8.0 Beta 3
Next
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1290: Default value and ALTER...TYPE