I'm using the latest source code (PostgreSQL 9.6devel)
From: dbx_c(at)hotmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: [BUGS] Issue when using ltree
Date: Wed, 26 Aug 2015 14:42:35 +0800
In the regress test of ltree module .
--this query return false
SELECT 'a.b.c.d.e'::ltree ~ '*{1}.!b.*.!c.*.e';
?column?
----------
f
(1 row)
--this query return true
SELECT 'a.b.c.d.e'::ltree ~ '*{1}.!b.*{1}.!c.*.e';
?column?
----------
t
(1 row)
I think if the second query return true, the first query should return true too (Obviously the "*" is contain the "*{1}").
Am i right?