PostgreSQL Adapter Project - Code Review 1 Changes

From CDOT Wiki
Revision as of 10:08, 20 April 2011 by Gbatumbya (talk | contribs) (→‎General Research)
Jump to: navigation, search

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

PostgreSQLSchemaManager

Scripts

postgrecreate.sql

postgresetup.sql

postgredrop.sql

Retrieved from "https://wiki.cdot.senecapolytechnic.ca/w/index.php?title=PostgreSQL_Adapter_Project_-_Code_Review_1_Changes&oldid=63325"