Typecasting and database functions

Typecasting

Controller:

@users = User.select("income::BigInt AS bg_income").sorted(params[:sort], "bg_income ASC")

View:

<th class="ui-state-default"><%= link_to_sorted "Income", 'bg_income' %></th>

Database functions

Controller:

@users = User.select("inet_aton(`ip_address`) AS in_ip").sorted(params[:sort], "in_ip ASC")

View:

<th class="ui-state-default"><%= link_to_sorted "IP address", 'in_ip' %></th>