[Dbix-class] NOT IN queries

[Dermot]

2009/10/1 Cory Watson <jheephat at gmail.com>:
> On Thu, Oct 1, 2009 at 3:22 PM, Cory Watson <jheephat at gmail.com> wrote:
>> On Thu, Oct 1, 2009 at 3:18 PM, Dermot <paikkos at googlemail.com> wrote:
>>> Hi,
>>>
>>> I suspect the answer to the question, "can I use
>>> DBIx::Class::Resultset to do a sql query like this":
>>>
>>> SELECT * FROM countries where iso2letter NOT IN ('GB','IE', 'HK','US');
>>
>> Isn't it just:
>>
>> ->search({ iso2letter => { '-not-in' => [qw(GB IE HK US)] })

Thanx for putting me straight on that.

Is this construct within search() from SQL::Abstract?  I can't see it
within the DBIx::Class docs.

Dp.