How to compare the results of two queries?
От | Juan Daniel Santana Rodés |
---|---|
Тема | How to compare the results of two queries? |
Дата | |
Msg-id | 52386E5F.8080505@estudiantes.uci.cu обсуждение исходный текст |
Ответы |
Re: How to compare the results of two queries?
Re: How to compare the results of two queries? Re: How to compare the results of two queries? Re: How to compare the results of two queries? |
Список | pgsql-general |
I am developing a task in which I need to know how to compare the results of two queries ... I thought about creating a procedure which both queries received by parameters respectively. Then somehow able to run queries and return if both have the same result. As a feature of the problem, both queries are selection. Here I leave a piece of code I want to do. create or replace function compare(sql1 character varying, sql2 character varying) returns boolean as $body$ Declare Begin --here in some way to run both queries and then compare End; $body$ language 'plpgsql'; I've been studying and I found that there EXECUTE but to use it, first you should have used PREPARE, and in this case the values of the parameters are already made inquiries. For example the execution of the function would be something like ... select compare('select * from table1', 'select * from table2'); For this case the result is false, then the queries are executed on different tables. Thanks in advance. Best regards from Cuba. __________________________________________________ "Todos el 12 de Septiembre con una Cinta Amarilla" FIN A LA INJUSTICIA, LIBERENLOS YA!! http://www.antiterroristas.cu http://justiciaparaloscinco.wordpress.com
В списке pgsql-general по дате отправления: