public inbox for [email protected]  

help / color / mirror / Atom feed

From: Durumdara <[email protected]>
To: Ron Johnson <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: PLPGSQL - store fetched records in array of record
Date: Wed, 2 Jul 2025 16:26:39 +0200
Message-ID: <CAEcMXhmHuVg7kbcqekULOxckOYZRaTHkO4Es8vJeUQAT2wyJPg@mail.gmail.com> (raw)
In-Reply-To: <CANzqJaAGjTUSMm8fMp-8JOx70WpsjYoF5r-WpF__ZnSftGShJg@mail.gmail.com>
References: <CAEcMXhmEJjrqruc0RUSNeUiUzzCf7K_TxuUAzFZoNBi_UzQdzA@mail.gmail.com>
	<CANzqJaAGjTUSMm8fMp-8JOx70WpsjYoF5r-WpF__ZnSftGShJg@mail.gmail.com>

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 <[email protected]> ezt írta (időpont: 2025. júl. 2.,
Sze, 15:29):

> On Wed, Jul 2, 2025 at 8:21 AM Durumdara <[email protected]> wrote:
>
>> Hello!
>>
>> I have to store some fetched records into two lists (arrays) to work with
>> 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!
>

view thread (2+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: PLPGSQL - store fetched records in array of record
  In-Reply-To: <CAEcMXhmHuVg7kbcqekULOxckOYZRaTHkO4Es8vJeUQAT2wyJPg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox