@>是什么？ postgres中的运算符吗？ [英] what does the @> operator in postgres do?
问题描述
我在postgres 此处中遇到了一个查询，该查询使用 @> 在地球物体上的运算符。
I came across a query in postgres here which uses the @> operator on earth objects.
我到处搜索过，但在含义上空无一物该操作符（以及其他可能喜欢的操作符，例如： @< 等）。
I've searched everywhere, but have come up empty on the meaning of this operator (and likely others like it, eg: @<, etc...).
> 很明显。我还发现 @ 将获得某些东西的绝对价值。因此，我最好的猜测是，这<两个比对值的绝对大于吗？
> is obvious. I also found that @ will take the absolute value of something. So my best guess is this does an absolute greater than comparison of two values?
对吗？这在postgres文档中有记载吗？我更想知道操作员对地球物体的作用。
Is that correct? Is this documented somewhere in the postgres docs? I'm even more curious to understand what the operator does on earth objects.
谢谢！
推荐答案
通常， @> 是包含运算符。
In general @> is the "contains" operator.
它为几种数据类型定义。
It is defined for several data types.
- 数组： http://www.postgresql.org/docs/current/static/functions-array.html
- 范围类型： http://www.postgresql.org/docs/current/static/functions-range.html
- 几何类型： http://www.postgresql.org/docs/current/static/functions-geometry.html
- JSON（和JSONB）： http://www.postgresql.org/docs/current/static/functions-json.html
- arrays: http://www.postgresql.org/docs/current/static/functions-array.html
- range types: http://www.postgresql.org/docs/current/static/functions-range.html
- geometric types: http://www.postgresql.org/docs/current/static/functions-geometry.html
- JSON (and JSONB): http://www.postgresql.org/docs/current/static/functions-json.html
这篇关于@>是什么？ postgres中的运算符吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
