Action executed in 0.000

select * from depesz; » Blog Archive » indexable ” field like ‘%something’”

DSHL logo

for the long time everybody knew that you can’t use index on “LIKE” operations.

then came text_pattern_ops, so we could use indexes for prefix searches:

but what if i’d like to search for ‘%something’? not prefix, but suffix. in my example – what can i do to use indexes when searching for people from given domain?


type: article, format: blog


none yet

Post a Comment

* indicates a required field
anonymous (If you want to identify yourself, please sign in first.)
required This field is required.

Max size is 2 MB, aspect ratio 3:4 width:height
required This field is required.
Please include a short description.
required This field is required.

480 characters remaining.
is public

(Use this field if you have to. 3000 characters remaining.)
1 nickel + 100

Trackback URL