On Thu, 31 Jul 2003, Claudiu C. wrote:
> Nu se poate crea index dupa un substring ?
Cum sa nu?!
> lala=# CREATE INDEX mumu_denumirekey ON mumu
> (substring(denumire from 1 for 8));
CREATE INDEX mumu_denumirekey ON mumu using
btree((substring(denumire from 1 for 8)));
Indexul tau e eficient insa doar daca in clauzele WHERE ai
cautari de genul where substring(denumire from 1 for
8)='ceva'::varchar(8); Ar trebui sa te gindesti sa-ti proiectezi altfel
aplicatia.
--
Any views or opinions presented within this e-mail are solely those of
the author and do not necessarily represent those of any company, unless
otherwise expressly stated.
