PostgreSQL (PG) array functions and operators

operator	Description	Example	Results
=	Equals	Array[1.1,2.1,3.1]::int[] = array[1,2,3]	T
<>	Not equal to	array[1,2,3] <> array[1,2,4]	T
<	Less than	array[1,2,3] < array[1,2,4]	T
>	Greater than	array[1,4,3] > array[1,2,4]	T
<=	Less than or equal	array[1,2,3] <= array[1,2,3]	T
>=	Greater than or equal	array[1,4,3] >= array[1,4,3]	T
@>	Contains	array[1,4,3] @> array[3,1]	T
<@	are included	array[2,7] <@ array[1,7,4,2,6]	T
&&	Overlap (with common elements)	array[1,4,3] && array[2,1]	T
||	Arrays and Array strings	array[1,2,3] | | array[4,5,6]	{1,2,3,4,5,6}
||	Arrays and Array strings	array[1,2,3] | | ARRAY[[4,5,6],[7,8,9]]	{{1,2,3},{4,5,6},{7,8,9}}
||	element to array string	3 | | array[4,5,6]	{3,4,5,6}
||	Array-to-element-threaded	array[4,5,6] | | 7	{4,5,6,7}

This article is from a "simple to rely" blog, so be sure to keep this source http://wenxuehui.blog.51cto.com/12898974/1954880

PostgreSQL (PG) array functions and operators