MIME-Version: 1.0
References: <CAEcMXhmEJjrqruc0RUSNeUiUzzCf7K_TxuUAzFZoNBi_UzQdzA@mail.gmail.com>
 <CANzqJaAGjTUSMm8fMp-8JOx70WpsjYoF5r-WpF__ZnSftGShJg@mail.gmail.com>
In-Reply-To: <CANzqJaAGjTUSMm8fMp-8JOx70WpsjYoF5r-WpF__ZnSftGShJg@mail.gmail.com>
From: Durumdara <durumdara@gmail.com>
Date: Wed, 2 Jul 2025 16:26:39 +0200
Message-ID: <CAEcMXhmHuVg7kbcqekULOxckOYZRaTHkO4Es8vJeUQAT2wyJPg@mail.gmail.com>
Subject: Re: PLPGSQL - store fetched records in array of record
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000002f8aa30638f30da7"
Archived-At: <https://www.postgresql.org/message-id/CAEcMXhmHuVg7kbcqekULOxckOYZRaTHkO4Es8vJeUQAT2wyJPg%40mail.gmail.com>
Precedence: bulk

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

Sorry.
I forgot to mention that I have two arrays (records).

One for the modifiable elements, and one for the checkable elements.

If there is a conflict between the actual mod. item and one of the
checkable items, the checkable item will move to the end of the
modification list.
And the actual mod. item starting time could be changed in this process.

First I imagined a temporary table, but I felt this has too much overhead
against an "in memory" array.
UPDATE, INSERT, DELETE and reopen after each modification.


Ron Johnson <ronljohnsonjr@gmail.com> ezt =C3=ADrta (id=C5=91pont: 2025. j=
=C3=BAl. 2.,
Sze, 15:29):

> On Wed, Jul 2, 2025 at 8:21=E2=80=AFAM Durumdara <durumdara@gmail.com> wr=
ote:
>
>> Hello!
>>
>> I have to store some fetched records into two lists (arrays) to work wit=
h
>> them.
>>
>
> There's almost certainly a way to do what you need done without using
> arrays.  Might require a bit of rethinking, though.
>
> --
> Death to <Redacted>, and butter sauce.
> Don't boil me, I'm still alive.
> <Redacted> lobster!
>

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

<div dir=3D"ltr">Sorry.=C2=A0<div>I forgot to mention that I have two array=
s (records).<div><br></div><div>One for the modifiable elements, and one fo=
r the checkable elements.</div><div><br></div><div>If there is a conflict=
=C2=A0between the actual mod. item and one of the checkable items, the chec=
kable item will move=C2=A0to the end of the modification list.</div><div>An=
d the actual mod. item starting time could be changed in=C2=A0this process.=
</div><div><br></div><div>First I imagined a temporary table, but I felt th=
is has too much overhead against an &quot;in memory&quot; array.<br>UPDATE,=
 INSERT, DELETE and reopen after each modification.</div><div><br></div></d=
iv></div><br><div class=3D"gmail_quote gmail_quote_container"><div dir=3D"l=
tr" class=3D"gmail_attr">Ron Johnson &lt;<a href=3D"mailto:ronljohnsonjr@gm=
ail.com">ronljohnsonjr@gmail.com</a>&gt; ezt =C3=ADrta (id=C5=91pont: 2025.=
 j=C3=BAl. 2., Sze, 15:29):<br></div><blockquote class=3D"gmail_quote" styl=
e=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);paddin=
g-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">On Wed, Jul 2, 2025 at 8:21=
=E2=80=AFAM Durumdara &lt;<a href=3D"mailto:durumdara@gmail.com" target=3D"=
_blank">durumdara@gmail.com</a>&gt; wrote:</div><div class=3D"gmail_quote">=
<blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-=
left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">Hello!<b=
r><br>I have to store some fetched records into=C2=A0two lists (arrays) to =
work with them.<br></div></blockquote><div><br></div><div>There&#39;s almos=
t certainly a way to do what you=C2=A0need done without using arrays.=C2=A0=
 Might require a bit of rethinking, though.</div><div>=C2=A0</div></div><sp=
an class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D=
"gmail_signature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sa=
uce.<div>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Redacted&=
gt; lobster!</div></div></div></div></div></div>
</blockquote></div>

--0000000000002f8aa30638f30da7--