On Fri, 27 Apr 2001, [iso-8859-1] Hans-Jürgen Schönig wrote:
> Is there any possibility to make PostgreSQL use indexes when working
> with regular expressions?
>
> performance=# EXPLAIN SELECT * FROM perftest WHERE id=100;
> NOTICE: QUERY PLAN:
>
> Index Scan using idx_id_perftest on perftest
Is there any possibility to make PostgreSQL use indexes when working
with regular expressions?
performance=# EXPLAIN SELECT * FROM perftest WHERE id=100;
NOTICE: QUERY PLAN:
Index Scan using idx_id_perftest on perftest (cost=0.00..4.98 rows=1
width=20)
EXPLAIN
performance=# EXPLAIN SELECT *
