Re: [Phpwiki-talk] Unworkable solution to SQL problem

[Arno H. <aho...@in...>]

> This is a bit off, but I have been thinking about the problem on
> Sourceforge with the query:
> I was reading the docs for Postgresql this weekend and it supports UNION,
> and INTERSECT.

Yes, union or subselects are among the things that mySQL is really lacking. 
When it comes down to more sophisticated stuff, mySQL is basically an SQL 
frontend to a filesystem. 

> I think subselects are more efficient, if the database knows how to
> optimize for them.

I have two SQL books by SQL guru Joe Celko and it seems he favours 
subselects over joins as well.

Anyway, right now there's no other way for mySQL. But your thinking is not 
too far off.

/Arno

p.s. did you see the search patch I added for mySQL?