3 ms·
> where you can at least write a test and assert it's doing the right thing SQL is code. PL/pgSQL is code. Code can be tested. Code should be tested. You don't
by phoe-krk 7y ago
> where you can at least write a test and assert it's doing the right thing
SQL is code. PL/pgSQL is code. Code can be tested. Code should be tested. You don't even need to leave the database to write tests for SQL or PL/pgSQL[1].
[1] https://pgtap.org/ https://pgtap.org/