MIME-Version: 1.0
References: <CAONhAovOas_XLigiebcfL5_q9M2iCHwG5hkYQk0L0qh_8RoQEw@mail.gmail.com>
In-Reply-To: <CAONhAovOas_XLigiebcfL5_q9M2iCHwG5hkYQk0L0qh_8RoQEw@mail.gmail.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Wed, 19 Feb 2025 09:31:33 -0500
Message-ID: <CAKAnmmLoiQGtnL4is9LUEynM7MAO6_KkMYSjME_nTNuThR-Ehw@mail.gmail.com>
Subject: Re: ERROR: stack depth limit exceeded
To: csanyipal@gmail.com
Cc: general pgsql <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000786033062e7f9f6c"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmmLoiQGtnL4is9LUEynM7MAO6_KkMYSjME_nTNuThR-Ehw%40mail.gmail.com>
Precedence: bulk

--000000000000786033062e7f9f6c
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Not related to the main question, but that query could use a little
adjustment. Something like:

WITH x AS (
  select kelt from javaink_forgalma
  where en_kaptam is true and az_aru_neve =3D 'nyugd=C3=ADjam'
  order by kelt desc limit 2
)
,y AS (select min(kelt) from x)
,z AS (select max(kelt) from x)
INSERT INTO public.havonkenti_megtakaritasaink (ezen_idokozben,
megtakaritva_rsd, kelt)
VALUES (
  (select tsrange(min,max,'[)') FROM y,z)
, (select sum(egysegar * ennyi_egyseg) from javaink_forgalma, y, z
   where a_penzem =3D 'RSD' and kelt >=3D min and kelt < max)
, DEFAULT
);

Also, it's best to use "timestamp with time zone" NOT "timestamp without
time zone" whenever possible (i.e. timestamptz not timestamp)

Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support

--000000000000786033062e7f9f6c
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Not related to the main question, but that query could use=
 a little adjustment. Something like:<div><br></div><div>WITH x AS (<br>=C2=
=A0 select kelt from javaink_forgalma<br>=C2=A0 where en_kaptam is true and=
 az_aru_neve =3D &#39;nyugd=C3=ADjam&#39;<br>=C2=A0 order by kelt desc limi=
t 2<br>)<br>,y AS (select min(kelt) from x)<br>,z AS (select max(kelt) from=
 x)<br>INSERT INTO public.havonkenti_megtakaritasaink=C2=A0(ezen_idokozben,=
 megtakaritva_rsd, kelt)<br>VALUES (<br>=C2=A0 (select tsrange(min,max,&#39=
;[)&#39;) FROM y,z)<br>, (select sum(egysegar * ennyi_egyseg) from javaink_=
forgalma, y, z<br>=C2=A0 =C2=A0where a_penzem =3D &#39;RSD&#39; and kelt &g=
t;=3D min and kelt &lt; max)<br>, DEFAULT<br>);</div><div><br></div>Also, i=
t&#39;s best to use &quot;timestamp with time zone&quot; NOT &quot;timestam=
p without time zone&quot; whenever possible (i.e. timestamptz not timestamp=
)<div><br></div><div>Cheers,</div><div>Greg</div><div><br></div><div>--<br>=
Crunchy Data - <a href=3D"https://www.crunchydata.com">https://www.crunchyd=
ata.com</a><br>Enterprise Postgres Software Products &amp; Tech Support<br>=
</div><div><br></div></div>

--000000000000786033062e7f9f6c--