Select
*
From
some_big_join
Where
(unit_use in ('U') and :param in ('U')) or
(unit_use not in ('U') and :param not in ('U'))

The portion of the query that tests a parameter against a value isn't supported in Firebird.

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Ali Gökçen
Sent: Thursday, October 20, 2005 1:02 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Conditional conundrum

Hi Rick,
I couldn't be sure about your problem and my solution..
Can you paste your real query here?

Ali

--- In firebird-support@yahoogroups.com, "Rick Debay" <rdebay@r...>
wrote:

>
> 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
>

------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/67folB/TM
--------------------------------------------------------------------~->

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links