Re: Abstract Search question

[prev] [thread] [next] [Date index for 2004/12/23]

On Wednesday 22 December 2004 01:56 pm, Peter Speltz wrote:
> cool.  thanks. how do you express (A and B) or (A and C) in SQL::Abstract.
> Its not coming to me at moment.
>
>

[ {A => 'mike', B => 'sam'}, {A => 'mike', C => 'huck'} ]

I think thats correct. 

Also, I did email the author, Nathan Wiger, and he sent me a patch to be able 
to say:

  { A => 'tom', NEST, [{B => 'huck'}, {C => 'jim'}] }

which results in: 

 A and (B or C)

He also added AND and OR along with the NEST. Hopefully it'll be on cpan soon.

Andy