[GENERAL] LIKE and indexes?

[Alexander Jerusalem]

Hi,

Can anyone telle me if and when a LIKE query uses an index? I've compiled 
postgres with locale support. Does that have any influence indexes?

thanks,

Alexander Jerusalem


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster