How can I control whether to execute a query or not? - Mailing list pgsql-general

From mbenzid@yahoo.de (Mounir Benzid)
Subject How can I control whether to execute a query or not?
Date
Msg-id 209b95b8.0111050422.db40c5d@posting.google.com
Whole thread Raw
List 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 by date:

Previous
From: Gabriel Fernandez
Date:
Subject: Problems of precision with float8 type
Next
From: "steve boyle"
Date:
Subject: Requesting features - is there a correct way of doing it?