method

quote

v3.0.5 - Show latest stable - 0 notes - Class: ActiveRecord::ConnectionAdapters::PostgreSQLAdapter

quote(value, column = nil) public

Quotes PostgreSQL-specific data types for SQL input.

# File activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb, line 317
      def quote(value, column = nil) #:nodoc:
        return super unless column

        if value.kind_of?(String) && column.type == :binary
          "'#{escape_bytea(value)}'"
        elsif value.kind_of?(String) && column.sql_type == 'xml'
          "xml '#{quote_string(value)}'"
        elsif value.kind_of?(Numeric) && column.sql_type == 'money'
          # Not truly string input, so doesn't require (or allow) escape string syntax.
          "'#{value}'"
        elsif value.kind_of?(String) && column.sql_type =~ /^bit/
          case value
            when /^[01]*$/
              "B'#{value}'" # Bit-string notation
            when /^[0-9A-F]*$/i
              "X'#{value}'" # Hexadecimal notation
          end
        else
          super
        end
      end

quote

Related methods

Flowdock - Team Inbox With Chat