digoal
2023-01-10
PostgreSQL , PolarDB , ltree
ltree是PG一个很老的插件, 通常被用于表示树状关系值, x.y.x.xxxx, 支持gist索引, 进行like, prefix, suffix等高速搜索.
PG 16 ltree 支持大小写字母,数字,下划线,连字符 A-Za-z0-9_-
, 值长度增加到1000个字符.
Allow hyphens in ltree labels
author Andrew Dunstan <andrew@dunslane.net>
Fri, 6 Jan 2023 21:03:19 +0000 (16:03 -0500)
committer Andrew Dunstan <andrew@dunslane.net>
Fri, 6 Jan 2023 21:05:46 +0000 (16:05 -0500)
commit b1665bf01e5f4200d37addfc2ddc406ff7df14a5
tree b804c5a09ce361188e10c9d7b562499c5b003610 tree
parent a46a7011b27188af526047a111969f257aaf4db8 commit | diff
Allow hyphens in ltree labels
Also increase the allowed length of labels to 1000 characters
Garen Torikian
Discussion: https://postgr.es/m/CAGXsc+-mNg9Gc0rp-ER0sv+zkZSZp2wE9-LX6XcoWSLVz22tZA@mail.gmail.com