Re: @ operator

Thanks for reply, it is clear now =)

On 09/17/2015 08:34 PM, David G. Johnston wrote:
> On Thursday, September 17, 2015, David G. Johnston
> <david(dot)g(dot)johnston(at)gmail(dot)com <mailto:david(dot)g(dot)johnston(at)gmail(dot)com>> wrote:
>
> On Thursday, September 17, 2015, Антон Бушмелев
> <bushmelev(dot)aa(at)gmail(dot)com
> <javascript:_e(%7B%7D,'cvml','bushmelev(dot)aa(at)gmail(dot)com');>> wrote:
>
> Hello, google nothing for @ operator =(, what does this mean
> field1 <@ ( subquery ) ?
>
>
> It would depend on what field1 is.
>
> Typically <@ is a contains/contained-by operator. Is this context
> the subquery is checked to see if it contains the value of field1.
>
> David J.
>
>
> To clarify I think that it means that for each row returned by the
> subquery, the value of filed1 is checked to see if the field in the
> subquery contains the given value. Use use ANY/ALL to indicate
> whether to care if on,y so,e rows or all rows need match in order for
> the entire expression to pass.
>
> David J.