开发者

What is the <@ operator in PostgreSQL 8.4?

I am having trouble decyphering what this operator is doing. I know that it is somehow comparing the array's, but I can find no documentation on it. I also have tried >@ but that seems to error. Google yealded bad results ad when I search for "at operator" it isn't very specific. Any information would be much apprecia开发者_如何学JAVAted.

I also have not (at least I don't think so) defined any new operators in the database.

SELECT id 
FROM organizations
WHERE  ARRAY[56] <@ ancestry


From the manual:

<@  is contained by

When your array ancestry has the value 56, the result will be true.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜