Copy link
@SPodjasek

SPodjasek Jun 24, 2015

Author Contributor

According to docs WHERE can be normal condition, so to be totally proper it should be written as:

my $index = $table->add_index(name => 'myindex', options => [{using => 'hash'}, {where => {'upper(foo)' => 'bar', bar => 'foo'}}], fields => ['bar', 'lower(foo)']);

But this would require code similar to SQL::Abstract->where.