Downloads
Home   >   mailing lists

Re: PLPGSQL - store fetched records in array of record - Mailing list pgsql-general

From Durumdara
Subject Re: PLPGSQL - store fetched records in array of record
Date
Msg-id CAEcMXhmHuVg7kbcqekULOxckOYZRaTHkO4Es8vJeUQAT2wyJPg@mail.gmail.com
Whole thread Raw
In response to Re: PLPGSQL - store fetched records in array of record  (Ron Johnson <ronljohnsonjr@gmail.com>)
Responses Re: PLPGSQL - store fetched records in array of record
List pgsql-general
Tree view
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 írta (időpont: 2025. júl. 2., Sze, 15:29):
On Wed, Jul 2, 2025 at 8:21 AM Durumdara <durumdara@gmail.com> 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!

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: PLPGSQL - store fetched records in array of record
Next
From: Franklin Anderson de Oliveira Souza
Date:
Subject: Re: Simulate a PITR in postgresql 16