3 ms·
What I mean is you can't do select * from table where ts_query(...) order by relevance_metric but instead do select * from (
by ramraj07 3y ago
What I mean is you can't do
select *
from table
where ts_query(...)
order by relevance_metric
but instead do
select *
from (
select *
from table
where ts_query(...)
order by ts_rank(...)
limit 1000
)
order by relevance_metric
limit 10