actually I stored the pattern in col1. I want to get the row whose col1
pattern matches one string 'aaa'.
于2011年12月15日 4:43:37,Marti Raudsepp写到:
2011/12/14 Rural Hunter:
for example, the where condition is: where '' ~ col1. I created a normal
index on col1 but seems it is not used.
I ass
2011/12/14 Rural Hunter :
> for example, the where condition is: where '' ~ col1. I created a normal
> index on col1 but seems it is not used.
I assume you want to search values that match one particular pattern,
that would be col1 ~ ''
The answer is, only very simple patterns that start
for example, the where condition is: where '' ~ col1. I created a
normal index on col1 but seems it is not used.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance