q1.sql

SELECT
  "projects".*,
  ((
    ts_rank(
    (
      to_tsvector('english', coalesce("projects"."title"::text, '')) ||
      to_tsvector('english', coalesce("projects"."description"::text, ''))
    ),
    (
      to_tsquery('english', ''' ' || 'qui' || ' ''')), 0)
  )) AS pg_search_rank
FROM
  "projects"
WHERE
  ((
    (
      to_tsvector('english', coalesce("projects"."title"::text, '')) ||
      to_tsvector('english', coalesce("projects"."description"::text, ''))
    ) @@ (to_tsquery('english', ''' ' || 'qui' || ' '''))
  ))
ORDER BY pg_search_rank DESC, "projects"."id" ASC