Hi,
Could you suggest me how should I teduce the heap blocks to optimise the
query ?
Regards.
On Thursday, July 8, 2021, Atul Kumar wrote:
> Hi,
>
> I have one query like below :
>
>
> SELECT
> m.iMemberId "memberId",
>
Hello Ken,
On Fri, 2021-07-09 at 13:27 -0500, Kenneth Marshall wrote:
> On Fri, Jul 09, 2021 at 01:16:16PM +1000, rob stone wrote:
> > Hello,
> >
> > I am curious.
> >
> > NVL, DECODE and SELECT FROM dual are Oracle methods and these
> > appear in
> > your code.
> >
> > How did you make these w
On Fri, Jul 09, 2021 at 01:16:16PM +1000, rob stone wrote:
> Hello,
>
> I am curious.
>
> NVL, DECODE and SELECT FROM dual are Oracle methods and these appear in
> your code.
>
> How did you make these work in Postgres?
>
> Cheers,
> Rob
Hi Rob,
At a guess, they are using the Orafce PostgreS
Hello,
I am curious.
NVL, DECODE and SELECT FROM dual are Oracle methods and these appear in
your code.
How did you make these work in Postgres?
Cheers,
Rob
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 wrote:
> ((current_setting('env.groupid'::text))::integer)::numeric
>
> If you pass this value in directl
((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 r
