From: | "Rajesh Kumar Mallah(dot)" <mallah(at)trade-india(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Cc: | oleg(at)sai(dot)msu(dot)su |
Subject: | Ltree usage.. |
Date: | 2002-08-02 16:33:52 |
Message-ID: | 200208022203.52617.mallah@trade-india.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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 ~ '*.180.*' or path ~ '*.1.*'; is better
written as
Qry3: SELECT path from unified_data where path ~ '*.180|1.*' ;
also is qry3 better to Qry2 in terms of performance?
regds
mallah.
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Bartunov | 2002-08-02 17:00:38 | Re: Ltree usage.. |
Previous Message | Wei Weng | 2002-08-02 16:21:12 | Re: Seeking advice regarding a design problem |