Bo Maryniuk wrote: % Hi! % % There is an Oracle-only operator for a set differences, called % "MINUS" and seems like it is already known problem when it comes to % PostgreSQL. % % It is seen in a several places, like hard-coded directly in Java % code com.redhat.rhn.manager.system.SystemManager as well as in % web/modules/rhn/RHN/DB/DataSource/xml/Package_queries.xml as % "snapshot_unservable_package_list" query. % % Seems like there is no way to use PostgreSQL's "EXCEPT" along with % current query, so should we rewrite query in different way, like % "NOT IN" or and outer join?
https://fedorahosted.org/spacewalk/wiki/PostgreSQLPortingGuide#MINUSkeyword Regards, -- Michael Mráka Satellite Engineering, Red Hat _______________________________________________ Spacewalk-devel mailing list Spacewalk-devel@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-devel