Tom Lane wrote:
Joseph Shraibman <[EMAIL PROTECTED]> writes:
I notice in 7.3.3 the planner can't tell when a LIKE has no wildcards and is in reality an '='. Is this an easy change to make?
On what do you base that conclusion?
regression=# create table t1 (f1 text unique); NOTICE: CREATE TABLE / UNIQUE will create implicit index 't1_f1_key' for table 't1' CREATE TABLE regression=# explain select * from t1 where f1 like 'foo'; QUERY PLAN --------------------------------------------------------------------- Index Scan using t1_f1_key on t1 (cost=0.00..4.82 rows=1 width=32) Index Cond: (f1 = 'foo'::text) Filter: (f1 ~~ 'foo'::text) (3 rows)
regression=#
regards, tom lane
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])