| From: | jens <jens(dot)theisen(at)transversal(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | trivial like clauses and indexes question |
| Date: | 2005-10-19 19:28:16 |
| Message-ID: | 43569E50.5070808@transversal.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hello,
I'm trying to do a simple select with a like clause,
explain select * from test where name like '_100_100_100%';
QUERY PLAN
-------------------------------------------------------
Seq Scan on test (cost=0.00..589.54 rows=1 width=68)
Filter: ((name)::text ~~ '_100_100_100%'::text)
but it's not using any key though
explain select * from test where name = '_100_100_100';
QUERY PLAN
-------------------------------------------------------------------------
Index Scan using idx_nrm on test (cost=0.00..360.11 rows=104 width=68)
Index Cond: ((name)::text = '_100_100_100'::text)
is and my keys are defined as
Table "public.test"
Column | Type | Modifiers
--------+------------------------+-----------
name | character varying(100) |
Indexes:
"idx" btree (name varchar_pattern_ops)
"idx_nrm" btree (name)
What's the problem here? My locale isn't C, if this makes some difference.
Thanks for any help,
Jens
| From | Date | Subject | |
|---|---|---|---|
| Next Message | operationsengineer1 | 2005-10-19 19:36:10 | Re: FATAL: missing or erroneous pg_hba.conf file |
| Previous Message | Cristian Prieto | 2005-10-19 18:24:45 | SQL return value... |