Re: Abstract Search question

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

On Thu, Dec 23, 2004 at 10:21:21AM -0500, Andrew Hartford wrote:
> 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.

I'd rather something other than a plain word, that might be a field name,
was used to trigger this.

Just putting a '-' in front would be enough:

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

Tim.