Skip to content

Instantly share code, notes, and snippets.

@neektza

neektza/query.sql

Created September 26, 2014 10:40
Show Gist options
  • Save neektza/2dda3b34fb1a182a687a to your computer and use it in GitHub Desktop.
Save neektza/2dda3b34fb1a182a687a to your computer and use it in GitHub Desktop.
Download ZIP
Textacular error
Raw
query.sql
SELECT COUNT("entities".*, COALESCE(ts_rank(to_tsvector('english', "entities"."title"::text), plainto_tsquery('english', 'something'::text)), 0) + COALESCE(ts_rank(to_tsvector('english', "entities"."url"::text), plainto_tsquery('english', 'something'::text)), 0) + COALESCE(ts_rank(to_tsvector('english', "entities"."body"::text), plainto_tsquery('english', 'something'::text)), 0) + COALESCE(ts_rank(to_tsvector('english', "entities"."origin_id"::text), plainto_tsquery('english', 'something'::text)), 0) + COALESCE(ts_rank(to_tsvector('english', "entities"."feed_name"::text), plainto_tsquery('english', 'something'::text)), 0) + COALESCE(ts_rank(to_tsvector('english', "entities"."type_name"::text), plainto_tsquery('english', 'something'::text)), 0) + COALESCE(ts_rank(to_tsvector('english', "entities"."image"::text), plainto_tsquery('english', 'something'::text)), 0) + COALESCE(ts_rank(to_tsvector('english', "entities"."cached_tag_list"::text), plainto_tsquery('english', 'something'::text)), 0) AS "rank32383541819242241") FROM "entities" WHERE (to_tsvector('english', "entities"."title"::text) @@ plainto_tsquery('english', 'something'::text) OR to_tsvector('english', "entities"."url"::text) @@ plainto_tsquery('english', 'something'::text) OR to_tsvector('english', "entities"."body"::text) @@ plainto_tsquery('english', 'something'::text) OR to_tsvector('english', "entities"."origin_id"::text) @@ plainto_tsquery('english', 'something'::text) OR to_tsvector('english', "entities"."feed_name"::text) @@ plainto_tsquery('english', 'something'::text) OR to_tsvector('english', "entities"."type_name"::text) @@ plainto_tsquery('english', 'something'::text) OR to_tsvector('english', "entities"."image"::text) @@ plainto_tsquery('english', 'something'::text) OR to_tsvector('english', "entities"."cached_tag_list"::text) @@ plainto_tsquery('english', 'something'::text))
from /usr/local/var/rbenv/versions/2.1.1/lib/ruby/gems/2.1.0/gems/activerecord-4.1.4/lib/active_record/connection_adapters/postgresql_adapter.rb:822:in `async_exec'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment