Re: @ operator

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

In response to

  • @ operator at 2015-09-17 13:10:33 from Антон Бушмелев

Browse pgsql-general by date

  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