PostgreSQL Adapter Project - Code Review 1 Changes

General Research

• Can postgreSQL be configured to have the where clause use case insensitive compare for string values? i.e. (select 'Grace' = 'grace' => should return true)
• Add UUID generation to x64 versions
• Does extract(epoch from value) return milliseconds?
• What encoding (UTF-8 and/or UTF-16) does PostgreSQL use for unicode? Can this be configured per column?

Classes

PostgreSQLAdapter

• Add parentheses to enforce operation order
  • appendMatchExpression
• Implement setQueryTime with Timer object
  • if code variation is limited, extract to SQLAdapter
• Use toMetadataCase and toDatabaseCase instead of toLowerCase/toUpperCase
  • indexNameMatches
• Refactor escaping literals
  • May be make use isLiteral
• Implement query locking for aggregate queries (i.e. repeatable read + exclusive lock)