How can I control whether to execute a query or not?

Поиск
Список
Период
Сортировка
От mbenzid@yahoo.de (Mounir Benzid)
Тема How can I control whether to execute a query or not?
Дата
Msg-id 209b95b8.0111050422.db40c5d@posting.google.com
обсуждение исходный текст
Список pgsql-general
Hallo!
I'm using an interface to access my postgres 7.0.3 DB.

What I need is a switch to control the execution of queries:
select 'execute' as control,col1 from table1 where col1=? and control=?;

So, only if the 2nd ? contains the string "execute" the query will be executed.
But postgres doesn't except virtually declared columns in the where clause, so
is there a way to do this in postgres?

Thanks
Mounir

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

Предыдущее
От: Gabriel Fernandez
Дата:
Сообщение: Problems of precision with float8 type
Следующее
От: "steve boyle"
Дата:
Сообщение: Requesting features - is there a correct way of doing it?