Search if a value exists in postgresql ltree-CodePudding

Home > OS > Search if a value exists in postgresql ltree

Search if a value exists in postgresql ltree

Time：08-25

I am trying to check if a particular value exists in a list of ltree column. For example path column contains values {1.2.270, 1.270.3, 1.302.270.70}. I am trying to find if the value 270 exists in any of these 3 paths. But it is not working if I am using IN or ANY keywords.

CodePudding user response：

Use documentation

SELECT '{1.2.270, 1.270.3, 1.302.270.70}'::ltree[] ~ lquery('*.270.*')

Page link：https//www.codepudding.com/os/521643.html

Prev:range between interval that does not include the first row

Next:BOM - multiple child to one parent relationship

Tags：

sql

postgresql

contains

ltree

Links：
CodePudding