Thread: Comprehensive operator list

Comprehensive operator list

From

Thom Brown

Date:

23 November 2009, 15:09:53

Hi all,

Does anyone know if there's a full list of operators and their usage anywhere? What I'm after is a combination of what is provided in separate sections in the documentation and what the pg_operator catalog lists. Or even a generic operator list. For example: @> generally means left is contained in right.

Thanks

Thom

Re: Comprehensive operator list

From

Merlin Moncure

Date:

23 November 2009, 15:24:32

On Mon, Nov 23, 2009 at 11:06 AM, Thom Brown <thombrown@gmail.com> wrote:
> Hi all,
>
> Does anyone know if there's a full list of operators and their usage
> anywhere?  What I'm after is a combination of what is provided in separate
> sections in the documentation and what the pg_operator catalog lists.  Or
> even a generic operator list.  For example: @> generally means left is
> contained in right.

from psql,
\do
\doS

(which one to call depends on version) gives a lot of info.

merlin

Re: Comprehensive operator list

From

Thom Brown

Date:

23 November 2009, 15:26:56

2009/11/23 Merlin Moncure <mmoncure@gmail.com>

On Mon, Nov 23, 2009 at 11:06 AM, Thom Brown <thombrown@gmail.com> wrote:
> Hi all,
>
> Does anyone know if there's a full list of operators and their usage
> anywhere? What I'm after is a combination of what is provided in separate
> sections in the documentation and what the pg_operator catalog lists. Or
> even a generic operator list. For example: @> generally means left is
> contained in right.

from psql,
\do
\doS

(which one to call depends on version) gives a lot of info.

merlin

Thanks Merlin. That looks useful :)

Thom