Re: WHERE CLAUSE - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: WHERE CLAUSE
Date
Msg-id 20010926145225.A25536@svana.org
Whole thread Raw
In response to WHERE CLAUSE  ("Sameer Maggon" <sameermaggon123@hotmail.com>)
List pgsql-general
On Wed, Sep 26, 2001 at 10:00:57AM +0530, Sameer Maggon wrote:
> Hi,
>
>   Well i have seen somewhere
>           WHERE somefiled @ '{123,324}'
>
>   what does this mean

Postgres supports many many operators on all sorts of different types. It
depends on the exact definitions of the fields but I think it's some kind of
intersection operator.

In psql, type \do to get a list, look for @.

HTH,
--
Martijn van Oosterhout <kleptog@svana.org>
http://svana.org/kleptog/
> Magnetism, electricity and motion are like a three-for-two special offer:
> if you have two of them, the third one comes free.

pgsql-general by date:

Previous
From: T.R.Missner@Level3.com
Date:
Subject: trigger insert duplicate rows question
Next
From: Martijn van Oosterhout
Date:
Subject: Re: trigger insert duplicate rows question