Re: selectivity function - Mailing list pgsql-hackers

From Tom Lane
Subject Re: selectivity function
Date
Msg-id 2460228.1653602061@sss.pgh.pa.us
Whole thread Raw
In response to Re: selectivity function  (Greg Hennessy <greg.hennessy@gmail.com>)
Responses Re: selectivity function  (Greg Hennessy <greg.hennessy@gmail.com>)
List pgsql-hackers
Greg Hennessy <greg.hennessy@gmail.com> writes:
> On Thu, May 26, 2022 at 3:10 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Attaching a support function to a SQL-language function seems pretty
>> weird to me.

> Is there a way to set the selectivity of a SQL-language function?

I think it'd work if you prevented inlining, but doing so would defeat
most of the value of writing it as a SQL function as opposed to (say)
plpgsql.  Can you do anything useful with attaching selectivity estimates
to the functions it references, instead?

            regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Remove support for Visual Studio 2013
Next
From: Michael Paquier
Date:
Subject: Re: pg_upgrade test writes to source directory