SQL codes on Controller

I use the SQL code in the controller as follow:

sql = ActiveRecord::Base.connection();
@countlikes = sql.execute("SELECT COUNT(rateint) as result FROM
rates");

But it returns the resuls as #<PGresult:0xb6ea00e0> in the view i.e.
@countlikes = #<PGresult:0xb6ea00e0>

I wanted the integer value. I am wondering how to use sql codes in the
controller

Kishoj B. wrote in post #966523:

I use the SQL code in the controller as follow:

sql = ActiveRecord::Base.connection();
@countlikes = sql.execute("SELECT COUNT(rateint) as result FROM
rates");

But it returns the resuls as #<PGresult:0xb6ea00e0> in the view i.e.
@countlikes = #<PGresult:0xb6ea00e0>

I wanted the integer value. I am wondering how to use sql codes in the
controller

You don't need to. Look up the docs for ActiveRecord::Calculations.

Best,