On Fri, 4 Dec 1998, Taral wrote:
> >hygea=> explain select * from comuni where nome = 'A%';
> >NOTICE: QUERY PLAN:
> >Index Scan using nome_comune_idx on comuni (cost=2.05 size=2 width=84)
> >^
>
> The question was about LIKE, not =. Because LIKE uses regexp-style matching and
> we have no
> >hygea=> explain select * from comuni where nome = 'A%';
> >NOTICE: QUERY PLAN:
> >Index Scan using nome_comune_idx on comuni (cost=2.05 size=2 width=84)
> >^
>
> The question was about LIKE, not =. Because LIKE uses regexp-style matching and
> we have no substring index functionality, it
Hello Taral,
venerdì, 4 dicembre 98, you wrote:
>>hygea=> explain select * from comuni where nome = 'A%';
>>NOTICE: QUERY PLAN:
>>Index Scan using nome_comune_idx on comuni (cost=2.05 size=2 width=84)
>>^
T> The question was about LIKE, not =. Because LIKE uses regexp-style matching and
T
