John Burger <john@xxxxxxxxx> writes:
> create unique index ix_allWords_lower on allWords (lower(word));
> To my surprise, the planner does not seem to realize that only one
> row can result from using this index:
> I would think UNIQUE => one row is pretty obvious - what am I
> missing? (Unless it's that I'm still stuck in 7.4.)
That would be the problem :-( ... a look at the code suggests that the
ability to do anything intelligent with expression indexes was added
in 8.0.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
