On: Creating a search engine with PostgreSQL

[ramraj07]

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