Search Postgresql Archives

Re: @ operator

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.g.johnston@xxxxxxxxx> wrote:
On Thursday, September 17, 2015, Антон Бушмелев <bushmelev.aa@xxxxxxxxx> 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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux