[GENERAL] Recursive function

2013-11-22 Thread Juan Daniel Santana Rodés
Hi everyone... I have a problem. I am programming a recursive function in plpgsql language. This function use a cursor and when the function try to call the same function throw a exception that it say me that the cursor is using. My friends how I can to resolve this problem. Regards!! -- Sent

[GENERAL] How to evaluate if a query is correct?

2013-09-18 Thread Juan Daniel Santana Rodés
Hi my friends... I wrote in the last post a question similiar to this. But in this post I clarify better the previous question. I need know how to evaluated if a query is correct without execute it. When I say if a query is correct, is that if I run the query, it did not throw an exception. Fo

Re: [GENERAL] How to compare the results of two queries?

2013-09-17 Thread Juan Daniel Santana Rodés
El 17/09/13 12:56, Igor Neyman escribió: -Original Message- From: Juan Daniel Santana Rodés [mailto:jdsant...@estudiantes.uci.cu] Sent: Tuesday, September 17, 2013 12:51 PM To: Igor Neyman Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] How to compare the results of two queries

Re: [GENERAL] How to compare the results of two queries?

2013-09-17 Thread Juan Daniel Santana Rodés
El 17/09/13 12:02, Igor Neyman escribió: -Original Message- From: Juan Daniel Santana Rodés [mailto:jdsant...@estudiantes.uci.cu] Sent: Tuesday, September 17, 2013 11:54 AM To: Igor Neyman Subject: Re: [GENERAL] How to compare the results of two queries? El 17/09/13 11:27, Igor Neyman

[GENERAL] How to compare the results of two queries?

2013-09-17 Thread Juan Daniel Santana Rodés
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 qu

[GENERAL] ¿Cómo comparar el resultado de dos consultas?

2013-09-16 Thread Juan Daniel Santana Rodés
Buenas... Estoy desarrollando una tarea en la cual necesito saber cómo comparar el resultado de dos consultas... He pensado en crear un procedimiento el cual reciba por parámetros ambas consultas respectivamente. Luego de alguna forma poder ejecutar las consultas y devolver si ambas tienen el m