Issue Type: Improvement Created: 2009-02-07T07:31:45.000+0000 Last Updated: 2012-11-20T20:53:36.000+0000 Status: Closed Fix version(s): Reporter: Chris (binaryexp) Assignee: None Tags: - Zend_Db_Select
Related issues: Attachments:
I have noticed that there is now support for UNION queries, but still no INTERSECT support. It would be nice to also have intersection support when using postgres, etc, though I believe MySQL does not support it anyway.
Posted by Kamil Nowakowski (kamiln) on 2009-02-07T07:35:15.000+0000
you can achive this by using join see http://www.bitbybit.dk/carsten/blog/?p=71
Posted by Chris (binaryexp) on 2009-02-07T07:55:07.000+0000
It may be possible to use JOIN, depending on the queries. Besides, I think JOIN could potentially be far slower than INTERSECT.
Posted by Benjamin Eberlei (beberlei) on 2009-02-07T07:58:51.000+0000
shouldn't the SQL parser realize that and rebuild the statement?
however to the issue, Zend_Db_Select will only support features that can be done in all sql dialects supported. If you can do it by join though it might be a workaround for all those engines not supporting it. To get this issue through, you should provide generic intersect statements for all drivers, which would make it far easier to look through.
Posted by Rob Allen (rob) on 2012-11-20T20:53:36.000+0000
Bulk change of all issues last updated before 1st January 2010 as "Won't Fix".
Feel free to re-open and provide a patch if you want to fix this issue.
Have you found an issue?
See the Overview section for more details.