RE: Ways to "serialize" result set for later use?

2021-04-13 Thread Kevin Brannen
From: Adam Brusselback Sent: Monday, April 12, 2021 12:51 PM > Checking data (DML), if functions are doing the right things is something we > do in our code unit tests. This is exactly what I am writing, unit tests for my code (which is pl/pgsql). This is an ELT pipeline for my customers to b

Re: Ways to "serialize" result set for later use?

2021-04-12 Thread Adam Brusselback
> Checking data (DML), if functions are doing the right things is something we do in our code unit tests. This is exactly what I am writing, unit tests for my code (which is pl/pgsql). This is an ELT pipeline for my customers to bulk update their data in my system, with detailed error reporting f

RE: Ways to "serialize" result set for later use?

2021-04-12 Thread Kevin Brannen
From: Adam Brusselback Sent: Saturday, April 10, 2021 9:06 PM To: pgsql-general Subject: Ways to "serialize" result set for later use? Hey there everyone, I am going through the process of writing my first pgtap tests for my database, and I wanted to get some feedback on if my solution seems f