Joe Wilson <[EMAIL PROTECTED]> wrote: > > I would think it would not be too difficult to extend SQLite > to perform this type of transformation on a view. > > i.e., transform: > > SELECT columns0 from ( > SELECT columns1 WHERE condition1 > UNION (ALL) > SELECT columns2 WHERE condition2 > ) > WHERE condition3 > > to > > SELECT columns0 from ( > SELECT columns1 WHERE (condition1) AND (condition3) > UNION (ALL) > SELECT columns2 WHERE (condition2) AND (condition3) > } > > or am I neglecting something? >
We await your patch. -- D. Richard Hipp <[EMAIL PROTECTED]>
