From 06c23c4c7ff842f7c6237f3ac43fc9d19509a947 Mon Sep 17 00:00:00 2001 From: Sven Bohm Date: Mon, 21 Nov 2011 13:14:16 -0500 Subject: postgresql adapter handles quoting of not a number (NaN) and Infinity --- .../lib/active_record/connection_adapters/postgresql_adapter.rb | 9 +++++++-- 1 file changed, 7 insertions(+), 2 deletions(-) (limited to 'activerecord/lib/active_record/connection_adapters') diff --git a/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb b/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb index 2f01fbb829..0b102d787a 100644 --- a/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb +++ b/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb @@ -415,8 +415,13 @@ module ActiveRecord case value when Float - return super unless value.infinite? && column.type == :datetime - "'#{value.to_s.downcase}'" + if value.infinite? && column.type == :datetime + "'#{value.to_s.downcase}'" + elsif value.infinite? || value.nan? + "'#{value.to_s}'" + else + super + end when Numeric return super unless column.sql_type == 'money' # Not truly string input, so doesn't require (or allow) escape string syntax. -- cgit v1.2.3