pgtap: expected and obtained result are equal, yet the test fails
Date : March 29 2020, 07:55 AM
help you fix your problem You don't give all the details, but I suspect it's a data type mismatch. pgTAP tends to require exact matches. Try this: PREPARE result_want AS VALUES ('("2010-09-07 06:05:00+00",100.0)'::foo);
|
How do I write tests in Perl with pgTAP?
Date : March 29 2020, 07:55 AM
wish of those help pgTap is for parsing SQL output - output from running an SQL script via psql from the command line. An SQL script that contains pgTap SQL calls mixed in with the SQL statements that you wish to test. As such, DBI doesn't enter into it.
|
Procedure to get the parameters and result type of a PostgreSQL stored procedure?
Date : March 29 2020, 07:55 AM
This might help you What is the procedure to get the parameter and return types of a stored procedure? (Google is of no help :-( ). , Here is one way: SELECT pg_get_function_result(oid), pg_get_function_arguments(oid)
FROM pg_proc
WHERE proname = 'GetAllDx'
SELECT oid::regprocedure FROM pg_proc WHERE proname = 'GetAllDx'
|
Is it a good way to use pgTAP framework to test postgresql functions?
Date : March 29 2020, 07:55 AM
|
How to install pgTAP on Windows?
Date : March 29 2020, 07:55 AM
|