Re: Best method to compare subdomains

On 1/17/2013 1:12 AM, Sumit Raja wrote:
> On 16 January 2013 20:23, Robert James <srobertjames(at)gmail(dot)com
> <mailto:srobertjames(at)gmail(dot)com>> wrote:
>
> Is there a recommended, high performance method to check for
> subdomains?
>
> Something like:
> - www.google.com <http://www.google.com> is subdomain of
> google.com <http://google.com>
> - ilikegoogle.com <http://ilikegoogle.com> is not subdomain of
> google.com <http://google.com>
> ...
>
> Maybe the ltree extension will suit what you are trying to do?
> http://www.postgresql.org/docs/9.2/static/ltree.html

that would work great, if you reversed the word order ... so (one of
my domains), www.astronomy.santa-cruz.ca.us. becomes
.us.ca.santa-cruz.astronomy.www

I half expected to a see a function that would reverse the order of a
ltree's elements, ah well.