4 ms·
I am really glad to see "searching for phrases" feature for Full-Text Search, as doing that with POSIX was really painful operation for long text area fields.
by dsavinkov 10y ago
I am really glad to see "searching for phrases" feature for Full-Text Search, as doing that with POSIX was really painful operation for long text area fields.
- dragon_king 10y agoWhat does 'doing that with POSIX' mean? I have read this many times but I do not have a clear understanding.
- trungaczne 10y agoI think what he means is "doing it using Unix command line utilities", like grep.
- dsavinkov 10y agoI meant using something like t.long_text_field ~~ '\mexact phrase\M' in actual sql statement - https://www.postgresql.org/docs/9.5/static/functions-matching.html https://www.postgresql.org/docs/9.5/static/functions-matchin...