Re: SELECTing from a function where i don't want the results - Mailing list pgsql-admin

From David G. Johnston
Subject Re: SELECTing from a function where i don't want the results
Date
Msg-id CAKFQuwYKshD9ZDtQV=mYWSxJL8-86h_kQM7ysmaSZuckuiQxLw@mail.gmail.com
Whole thread Raw
In response to Re: SELECTing from a function where i don't want the results  (Holger Jakobs <holger@jakobs.com>)
Responses Re: SELECTing from a function where i don't want the results  (Wells Oliver <wells.oliver@gmail.com>)
List pgsql-admin
On Tuesday, July 7, 2020, Holger Jakobs <holger@jakobs.com> wrote:

You could combine the result with a NULL value, as any operations with NULL result in NULL.

SELECT mydelete(r) + NULL FROM sometable;

So now you have 100 rows containing null (assuming that indeed function result + unknown means something and you don’t just get an error) which is no better than what is the probably 100 rows of void output the OP is complaining about.

David J.

pgsql-admin by date:

Previous
From: Holger Jakobs
Date:
Subject: Re: SELECTing from a function where i don't want the results
Next
From: Wells Oliver
Date:
Subject: Re: SELECTing from a function where i don't want the results