PERFORM / FOUND, what's up?

Поиск
Список
Период
Сортировка
От Martin Brommer
Тема PERFORM / FOUND, what's up?
Дата
Msg-id 3eae35d4$0$49113$e4fe514c@news.xs4all.nl
обсуждение исходный текст
Ответы Re: PERFORM / FOUND, what's up?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Hi,

I'm trying to get an answer from a dynamic query using perform. The 
problem is that it sets the FOUND variable to true even when performing 
bogus queries.

Am I missing something here? The documentation says that PERFORM only 
sets FOUND to true if it finds and discards a row but doing something like:

qry := 'SELECT notafield FROM notatable'
PERFORM qry

Also sets FOUND to true, even more using a query like 'BLABLABLA'  also 
set found to true.

What am I doing wrong here?

Thanks for any help in advance,

Martin



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

Предыдущее
От: "Victor Yegorov"
Дата:
Сообщение: Re: replace function
Следующее
От: Rajesh Kumar Mallah
Дата:
Сообщение: Re: replace function