Re: Fix PL/Python metadata when there is no result - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Fix PL/Python metadata when there is no result
Date
Msg-id 19975.1331156958@sss.pgh.pa.us
Whole thread Raw
In response to Re: Fix PL/Python metadata when there is no result  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Fix PL/Python metadata when there is no result  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> On ons, 2012-03-07 at 15:59 -0500, Tom Lane wrote:
>> Or are we talking about two different things?

> I think so.  I'm wondering here how to detect whether the execution of a
> statement has yielded a result set at all.  (For example, you ran SELECT
> or INSERT ... RETURNING, versus CREATE TABLE or VACUUM.)

Got it.  I agree that throwing an error for resultset property inquiries
is reasonable in such cases, as long as there is some non-error-throwing
way to test whether a resultset was returned or not.

Still, it seems rather arbitrary to say that the row count property is
the thing to test for that purpose and no other is.  Why not return None
for any property that's not sensible?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Fix PL/Python metadata when there is no result
Next
From: Thom Brown
Date:
Subject: Re: Command Triggers, patch v11