| From: | Juan Daniel Santana Rodés <jdsantana(at)estudiantes(dot)uci(dot)cu> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | How to evaluate if a query is correct? |
| Date: | 2013-09-19 06:13:29 |
| Message-ID: | 523A9609.8090505@estudiantes.uci.cu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
For example...
create or replace function is_correct(query text) returns boolean as
$body$
Declare
Begin
-- Here I check if the query is correct, but I can't execute this
query, because it may make changes in the data base
End;
$body$
language 'plpgsql';
Greetings
__________________________________________________
"Todos el 12 de Septiembre con una Cinta Amarilla"
FIN A LA INJUSTICIA, LIBERENLOS YA!!
http://www.antiterroristas.cu
http://justiciaparaloscinco.wordpress.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jayadevan | 2013-09-19 06:33:16 | Re: Query - CPU issue |
| Previous Message | Kevin Grittner | 2013-09-19 06:09:24 | Re: Query - CPU issue |