in reply to Combined SQL Queries (e.g., EXCEPT) and DBIx::Class
At first attempt, I can't even use search_literal because the string is stuffed into a WHERE clause:What about:becomes something like$schema->resultset('foo')->search_literal('EXCEPT SELECT * FROM bar')SELECT * FROM foo WHERE ( EXCEPT SELECT * FROM BAR )
Just _might_ fall into the category of "Hack" though :)$schema->resultset('foo')->search_literal( '1=1) EXCEPT (SELECT * FROM + bar' )
|
|---|