Hi Oleg,
It does not yeild the correct result for me.
I am providing more details this time.
path is ltree [] for me not ltree,
Column | Type |Modifiers
++--
On Fri, 2 Aug 2002, Rajesh Kumar Mallah. wrote:
>
> Hi Oleg,
>
> I am trying to use contrib/ltree for one of my applications.
>
> the query below works fine for me.
>
> Qry1: SELECT path from unified_data where path ~ '*.180.*' and path ~ '*.1.*';
>
> is there any way of compacting it for e
Hi Oleg,
I am trying to use contrib/ltree for one of my applications.
the query below works fine for me.
Qry1: SELECT path from unified_data where path ~ '*.180.*' and path ~ '*.1.*';
is there any way of compacting it for example
Qry2: SELECT path from unified_data where path ~ '*
