Re: ERROR: stack depth limit exceeded
| От | Greg Sabino Mullane |
|---|---|
| Тема | Re: ERROR: stack depth limit exceeded |
| Дата | |
| Msg-id | CAKAnmmLoiQGtnL4is9LUEynM7MAO6_KkMYSjME_nTNuThR-Ehw@mail.gmail.com обсуждение исходный текст |
| Ответ на | ERROR: stack depth limit exceeded (Csányi Pál <csanyipal@gmail.com>) |
| Список | pgsql-general |
Not related to the main question, but that query could use a little adjustment. Something like:
Also, it's best to use "timestamp with time zone" NOT "timestamp without time zone" whenever possible (i.e. timestamptz not timestamp)
WITH x AS (
select kelt from javaink_forgalma
where en_kaptam is true and az_aru_neve = 'nyugdíjam'
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 = 'RSD' and kelt >= min and kelt < max)
, DEFAULT
);
select kelt from javaink_forgalma
where en_kaptam is true and az_aru_neve = 'nyugdíjam'
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 = 'RSD' and kelt >= min and kelt < max)
, DEFAULT
);
Cheers,
Greg
В списке pgsql-general по дате отправления: