Hi Lewis,
I am new to postgres.
Could you tell me how should I put the result on an analyzed temp table at
least ?
Please suggest.
Regards.
On Thursday, July 8, 2021, Michael Lewis <mle...@entrata.com> wrote:
> ((current_setting('env.groupid'::text))::integer)::numeric
>
> If you pass this value in directly as part of the query string, how does
> it perform? It seems like calling the function to get this value may be
> creating a planning problem with the value unknown at plan time. If you
> were able to put the result on an analyzed temp table at least, I'd expect
> that the planner would have enough info to make good decisions.
>
