Any suggestions on how to use the overlaps operator? Using Postgresql..
I read the SQL::Abstract page after bottoming out on:
Cannot mix placeholder styles ":foo" and "?"
I found this in the docs:
my %where = (
user => 'nwiger',
completion_date => {
-not_between => ['2002-10-01', '2003-02-06']
}
);
Would give you:
WHERE user = ? AND completion_date NOT BETWEEN ( ? AND ? )
But it doesn't seem to recognize OVERLAPS the same way as BETWEEN:
(start_time,end_time)" => { -overlaps => [$pg_alpha, $pg_omega] }
generates:
WHERE ( ( ( (start_time,end_time) OVERLAPS $1 ) OR ( ...
Of course what I want is
WHERE ( ( ( ( start_time,end_time) OVERLAPS (?, ?)
I could simulate overlaps with some OR clauses, but I made a mistake with that
before, so I'd rather use the proper SQL function.
--
----------------------------------------------
Jason Thaxter GoMOOS
350 Commercial Street, Suite 308
Portland, ME 0410
Office: 207.773.0423
Tel: 207.228.1665
Email: [EMAIL PROTECTED]
----------------www.gomoos.org----------------
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/[email protected]/
