Re: [SQL] Ltree usage..

2002-08-02 Thread Rajesh Kumar Mallah.
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 ++--

Re: [SQL] Ltree usage..

2002-08-02 Thread Oleg Bartunov
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