| Subject | Re: [firebird-support] Optimise OR in WHERE |
|---|---|
| Author | Tim Ward |
| Post date | 2013-10-11T12:41:46Z |
On 11/10/2013 13:39, Kjell Rilbe wrote:
Duh... No, try this where clause:
AND ( (cast(WIDGET as vacrhar(10)) || '.' starting with coalesce(:param || '.', '') )
Actually it turns out that EXECUTE STATEMENT goes fast enough, so although slightly tacky I'll live with that for now.
Thanks for the suggestions.
-- Tim Ward