def coerce(value)
return nil if (value == nil || value == '') && @result != "text"
case @result
when "text"
return value
when "number"
return BigDecimal.new(value)
when "date"
return Date.strptime(value, @result_set.date_format)
when "time"
return DateTime.strptime("1/1/-4712 " + value, "%m/%d/%Y #{@result_set.time_format}")
when "timestamp"
return DateTime.strptime(value, @result_set.timestamp_format)
when "container"
return URI.parse("#{@result_set.server.scheme}://#{@result_set.server.host_name}:#{@result_set.server.port}#{value}")
end
end