[Dbix-class] How to search records with "IS NOT NULL"

Hi All

I want something like 'SELECT * FROM employee WHERE department IS NOT NULL'

I tried $schema->resultset('employee')->search({ department => {"IS" =>
"NOT NULL"}});

But it is not working...

Any help?

Thanks
-Ram

SQL::Abstract and DBIx::Class both treat undef as NULL. Just pass

=> { '!=', undef }

and it'll do the right thing.

|  Hi All
|
|  I want something like 'SELECT * FROM employee WHERE department IS NOT NULL'
|
| I tried $schema->resultset('employee')->search({ department => {"IS" => "NOT
|  NULL"}});
|
|  But it is not working...
|
|  Any help?
|

$rs->search( { department => { '!=', undef } } );

or

my $sql = 'IS NOT NULL';
$rs->search( { department => \$sql } )

Read the docs for SQL::Abstract
http://search.cpan.org/~nwiger/SQL-Abstract-1.22/lib/SQL/Abstract.pm

Fernan

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.