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

From: mbenzid(at)yahoo(dot)de (Mounir Benzid)
To: pgsql-general(at)postgresql(dot)org
Subject: How can I control whether to execute a query or not?
Date: 2001-11-05 12:22:50
Message-ID: 209b95b8.0111050422.db40c5d@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Lockhart 2001-11-05 14:19:28 Re: Sum(time) possible?
Previous Message Balaji Venkatesan 2001-11-05 11:24:51 Re: Limitations on PGSQL