Re: @ operator - Mailing list pgsql-general

From John McKown
Subject Re: @ operator
Date
Msg-id CAAJSdjjZyR=POQCoHGy49hm5poHQf4Rknpht_U-tH+hnfW8Brw@mail.gmail.com
Whole thread Raw
In response to @ operator  (Антон Бушмелев <bushmelev.aa@gmail.com>)
List pgsql-general
Your English is fine. @< is an "array is contained by" operator:


I assume that field1 is an array, as opposed to just a simple value variable. A simple value variable would be tested with something like: field1 IN ( subquery) . The @< tests that every value in the array field1 is also in the subquery. The subquery might contain other values, but it will contain _all_ values in field1.


On Thu, Sep 17, 2015 at 8:10 AM, Антон Бушмелев <bushmelev.aa@gmail.com> wrote:
Hello, google nothing  for @ operator =(,  what does this mean  field1 <@ ( subquery ) ?


ps: sorry for my english



--

Schrodinger's backup: The condition of any backup is unknown until a restore is attempted.

Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.

He's about as useful as a wax frying pan.

10 to the 12th power microphones = 1 Megaphone

Maranatha! <><
John McKown

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: @ operator
Next
From: "Quiroga, Damian"
Date:
Subject: Hiding name and version