PostgresSQL 数组包含@>

最新推荐文章于 2025-03-17 20:40:33 发布

转载

最新推荐文章于 2025-03-17 20:40:33 发布

· 1.6k 阅读

4 ·

版权

原文链接：http://www.cnblogs.com/ieayoio/p/5295446.html

文章标签：

#数据库

本文介绍了PostgreSQL数据库中9.18. Array Functions and Operators章节的内容，包括数组比较运算符如@>，并详细阐述了数组元素的比较方式、多维数组的处理顺序，以及不同版本的行为差异。此外，还提到了与数组操作相关的函数，如数组查找、分割等，以及它们的使用细节和示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

原文链接：http://www.postgresql.org/docs/9.5/static/functions-array.html

9.18. Array Functions and Operators

Table 9-45 shows the operators available for array types.

Table 9-45. Array Operators

Operator Description Example Result

= equal ARRAY[1.1,2.1,3.1]::int[] = ARRAY[1,2,3] t

<> not equal 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

<@ is contained by ARRAY[2,7] <@ ARRAY[1,7,4,2,6] t

&& overlap (have elements in common) ARRAY[1,4,3] && ARRAY[2,1] t

|| array-to-array concatenation ARRAY[1,2,3] || ARRAY[4,5,6] {1,2,3,4,5,6}

|| array-to-array concatenation ARRAY[1,2,3] || ARRAY[[4,5,6],[7,8,9]] { {1,2,3},{4,5,6},{7,8,9}}

|| element-t

Operator	Description	Example	Result
`=`	equal	`ARRAY[1.1,2.1,3.1]::int[] = ARRAY[1,2,3]`	`t`
`<>`	not equal	`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`
`<@`	is contained by	`ARRAY[2,7] <@ ARRAY[1,7,4,2,6]`	`t`
`&&`	overlap (have elements in common)	`ARRAY[1,4,3] && ARRAY[2,1]`	`t`
`\|\|`	array-to-array concatenation	`ARRAY[1,2,3] \|\| ARRAY[4,5,6]`	`{1,2,3,4,5,6}`
`\|\|`	array-to-array concatenation	`ARRAY[1,2,3] \|\| ARRAY[[4,5,6],[7,8,9]]`	`{ {1,2,3},{4,5,6},{7,8,9}}`
`\|\|`	element-t