Magnus Hagander wrote:
> I don't use the functional index part, but for new users I can see how
> that's certainly a *lot* easier. 

Can someone with modern hardware test to see if it's
still quite a bit slower than the extra column.  I had
tried it too years ago; and found the functional index
to be quite a bit slower:
but it'd be interesting to see if faster CPUs changed this.

---------------------------(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

Reply via email to