How to compare the results of two queries?

From: Juan Daniel Santana Rodés <jdsantana(at)estudiantes(dot)uci(dot)cu>
To: pgsql-general(at)postgresql(dot)org
Subject: How to compare the results of two queries?
Date: 2013-09-17 14:59:43
Message-ID: 52386E5F.8080505@estudiantes.uci.cu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2013-09-17 15:17:26 Re: How to compare the results of two queries?
Previous Message David Johnston 2013-09-17 14:50:42 Re: best practice for || set of rows --> function --> set of rows