> -----Original Message----- > From: Juan Daniel Santana Rodés [mailto:jdsantana@xxxxxxxxxxxxxxxxxx] > Sent: Tuesday, September 17, 2013 1:38 PM > To: Igor Neyman > Cc: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: 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@xxxxxxxxxxxxxxxxxx] > >> Sent: Tuesday, September 17, 2013 12:51 PM > >> To: Igor Neyman > >> Cc: pgsql-general@xxxxxxxxxxxxxx > >> Subject: Re: 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
