Subject | Conditional conundrum |
---|---|
Author | Rick Debay |
Post date | 2005-10-20T14:17:12Z |
I have a not-null char(1) field that can be 'U' or some other value. I
also have a stored procedure, that among other things needs to select
items based on a char(1) parameter.
The pseudo-SQL is:
Select * from table where (Field in ('U') and :param in ('U')) or (Field
not in ('U') and :param not in ('U'))
Parameter tests aren't legal to the planner ( 'Z' not in ('U') ), and I
can't branch to execute one query or another. Any ideas for a
conditional statement for the WHERE clause?
Thanks, Rick DeBay
also have a stored procedure, that among other things needs to select
items based on a char(1) parameter.
The pseudo-SQL is:
Select * from table where (Field in ('U') and :param in ('U')) or (Field
not in ('U') and :param not in ('U'))
Parameter tests aren't legal to the planner ( 'Z' not in ('U') ), and I
can't branch to execute one query or another. Any ideas for a
conditional statement for the WHERE clause?
Thanks, Rick DeBay