Am Donnerstag, den 30.07.2009, 08:16 +0200 schrieb Ivan Fomichev:
> Hello,
>
> Is there a conceptual obstacle to introduce NOT operator, that accepts
> hashref as an argument, like this:
>
> my ($where, @bind) = $sql->where(
> {
> -not => {
> id => {
> '>' => 5,
> '<' => 10,
> }
> }
> }
> );
> is_deeply(
> [$where, @bind],
> [' WHERE ( NOT ( ( id < ? AND id > ? ) ) )', 10, 5],
> '-not');
>
>
> Regards,
> Ivan
Remember that DBIx::Class uses SQL::Abstract which has the -not_between
operator you can use for that.
--
BR Alex
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
T-Systems Austria GesmbH Rennweg 97-99, 1030 Wien
Handelsgericht Wien, FN 79340b
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
Notice: This e-mail contains information that is confidential and may be
privileged.
If you are not the intended recipient, please notify the sender and then
delete this e-mail immediately.
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]
