Syntax error calling count on multisearch results

[jsierles]

With a Rails 4 app, I've added a single column to multisearch, and get a syntax error from Postgres 9.1 when calling count on the results:

irb(main):017:0> PgSearch.multisearch("olvidar").count
   (0.7ms)  SELECT COUNT("pg_search_documents".*, ((ts_rank((to_tsvector('simple', coalesce("pg_search_documents"."content"::text, ''))), (to_tsquery('simple', ''' ' || 'olvidar' || ' ''')), 0))) AS pg_search_rank) FROM "pg_search_documents"  WHERE (((to_tsvector('simple', coalesce("pg_search_documents"."content"::text, ''))) @@ (to_tsquery('simple', ''' ' || 'olvidar' || ' '''))))
PG::Error: ERROR:  syntax error at or near "AS"
LINE 1: ...ery('simple', ''' ' || 'olvidar' || ' ''')), 0))) AS pg_sear...
                                                             ^
: SELECT COUNT("pg_search_documents".*, ((ts_rank((to_tsvector('simple', coalesce("pg_search_documents"."content"::text, ''))), (to_tsquery('simple', ''' ' || 'olvidar' || ' ''')), 0))) AS pg_search_rank) FROM "pg_search_documents"  WHERE (((to_tsvector('simple', coalesce("pg_search_documents"."content"::text, ''))) @@ (to_tsquery('simple', ''' ' || 'olvidar' || ' '''))))
ActiveRecord::StatementInvalid: PG::Error: ERROR:  syntax error at or near "AS"

[daisybill-dev]

Are you using rails 4-0-stable? I ran into this same issue while using stable, but not with 4.0.0. I believe the reason is in here: rails/rails#10710

You should be able to fix the problem by using count(:all) rather than just count.

[jsierles]

Yep, that was the reason.