Re: [SQLObject] Using UNION, INTERSECT, EXCEPT set operations

[Oleg B. <ph...@ma...>]

On Wed, Jun 14, 2006 at 06:39:37AM -0500, Charles Duffy wrote:
> I'm in a situation where I'll be wanting to dynamically construct 
> strings of queries combined with set operations, with explicitly defined 
> grouping (as in "(A UNION B) INTERSECT C" as opposed to the default 
> behavior "A UNION (B INTERSECT C)").
> 
> Is there support in SQLObject for this? If not, is there a way I can 
> shoehorn it into happening?

   Look at sqlbuilder.py, see how LIKE, RLIKE and other operators are
implemented.

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.