Re: How to compare the results of two queries?

> -----Original Message-----
> From: Juan Daniel Santana Rodés [mailto:jdsantana(at)estudiantes(dot)uci(dot)cu]
> Sent: Tuesday, September 17, 2013 1:38 PM
> To: Igor Neyman
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] How to compare the results of two queries?
>
> El 17/09/13 12:56, Igor Neyman escribió:
> >
> >> -----Original Message-----
> >> From: Juan Daniel Santana Rodés [mailto:jdsantana(at)estudiantes(dot)uci(dot)cu]
> >> Sent: Tuesday, September 17, 2013 12:51 PM
> >> To: Igor Neyman
> >> Cc: pgsql-general(at)postgresql(dot)org
> >> Subject: Re: [GENERAL] How to compare the results of two queries?
> >>
> >> I want to know if there are other way to compare the result of two
> queries.
> >> Because the arguments will represent a query to execute and it can
> >> use everything sentence of SQL.
> >> If not there are other way, I wish know who are the limitations of EXCEPT.
> >> Greatens!!
> >> __________________________________________________
> >
> > In the modified function I put both queries in parenthesis, so this should
> allow pretty much anything in the query.
> >
> > Igor Neyman
> Thanks.
> I tested your code and worked fine.
> Now I only should catch the exception when the results of the querires has
> diferents munbers of columns.
> God bless you.
> __________________________________________________
> "Todos el 12 de Septiembre con una Cinta Amarilla"
> FIN A LA INJUSTICIA, LIBERENLOS YA!!
> http://www.antiterroristas.cu
> http://justiciaparaloscinco.wordpress.com

And of course, not just number of columns in the result sets, but their types should match as well.

Igor Neyman