maxnov

  * HTML / CSS
  * Javascript (client-side)
  * Ruby on Rails
  * Test-driven development
  * DevOps
  * API Design
  * Server-side development (high performance APIs)
  * iOS development

  SELECT d.id, d.meta FROM (
    SELECT id FROM data_rows, to_tsquery('query') AS q
    WHERE tsv @@ q ORDER BY ts_rank_cd(tsv, q) DESC LIMIT 5
  ) AS ids INNER JOIN data_rows d ON d.id = ids.id;

  SELECT id, meta->>'title' as title, meta FROM(
    SELECT id, meta FROM (
      SELECT id, meta, tsv
      FROM data_rows, plainto_tsquery('search query') AS q
      WHERE (tsv @@ q)
    ) AS t1 ORDER BY ts_rank_cd(t1.tsv, plainto_tsquery('search query')) DESC LIMIT 5
  ) AS t2;