a challenge with returning a table and testing with pgTAP

I had a nice little challenge getting a Set Equals test with pgTAP working recently. My function returns a table that contains data from across multiple tenants and I needed to be able to validate the result-set, but I ran into a problem with pgTAP set_seq VALUES being able to test it because the table is a “pseudo-type”. Here is how I got it working…