search sql

gistfile1.txt

--------------------------------------------------------------------------------------------------------
# FROM Global Search

SELECT     Count(*)
FROM       "pg_search_documents"
INNER JOIN
           (
                  SELECT "pg_search_documents"."id" AS pg_search_id,
                         (Ts_rank((To_tsvector('simple', COALESCE("pg_search_documents"."content"::text, ''))), (To_tsquery('simple', ''' '
                                || 'len'
                                || ' '''
                                || ':*')), 0)) AS rank
                  FROM   "pg_search_documents"
                  WHERE  (((
                                              To_tsvector('simple', COALESCE("pg_search_documents"."content"::text, ''))) @@ (to_tsquery('simple', ''' '
                                              || 'len'
                                              || ' '''
                                              || ':*'))))) AS pg_search_ce9b9dd18c5c0023f2116f
ON         "pg_search_documents"."id" = pg_search_ce9b9dd18c5c0023f2116f.pg_search_id
WHERE      "pg_search_documents"."searchable_type" = 'Question'


--------------------------------------------------------------------------------------------------------
# FROM Question Search

SELECT     Count(*)
FROM       "questions"
INNER JOIN
           (
                  SELECT "questions"."id" AS pg_search_id,
                         (Ts_rank((To_tsvector('simple', COALESCE("questions"."title"::text, ''))
                                || To_tsvector('simple', COALESCE("questions"."searchable_content"::text, ''))), (To_tsquery('simple', ''' '
                                || 'len'
                                || ' ''')), 0)) AS rank
                  FROM   "questions"
                  WHERE  (((
                                              To_tsvector('simple', COALESCE("questions"."title"::text, ''))
                                                     || To_tsvector('simple', COALESCE("questions"."searchable_content"::text, ''))) @@ (to_tsquery('simple', ''' '
                                              || 'len'
                                              || ' '''))))) AS pg_search_17d5efa695de036a7acb61
ON         "questions"."id" = pg_search_17d5efa695de036a7acb61.pg_search_id