How to evaluate if a query is correct?

Поиск
Список
Период
Сортировка
От Juan Daniel Santana Rodés
Тема How to evaluate if a query is correct?
Дата
Msg-id 523A9609.8090505@estudiantes.uci.cu
обсуждение исходный текст
Ответы Re: How to evaluate if a query is correct?  (David Johnston <polobo@yahoo.com>)
Re: How to evaluate if a query is correct?  (Rob Sargentg <robjsargent@gmail.com>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: Kevin Grittner
Дата:
Сообщение: Re: Query - CPU issue
Следующее
От: Jayadevan
Дата:
Сообщение: Re: Query - CPU issue