From: | John McKown <john(dot)archie(dot)mckown(at)gmail(dot)com> |
---|---|
To: | Антон Бушмелев <bushmelev(dot)aa(at)gmail(dot)com> |
Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: @ operator |
Date: | 2015-09-17 17:30:24 |
Message-ID: | CAAJSdjjZyR=POQCoHGy49hm5poHQf4Rknpht_U-tH+hnfW8Brw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Your English is fine. @< is an "array is contained by" operator:
http://www.postgresql.org/docs/9.4/interactive/functions-array.html
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(dot)aa(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Quiroga, Damian | 2015-09-17 17:32:16 | Hiding name and version |
Previous Message | David G. Johnston | 2015-09-17 17:27:11 | Re: @ operator |