Class | ActiveRecord::ConnectionAdapters::PostgreSQLAdapter |
In: |
lib/active_record/connection_adapters/postgresql_adapter.rb
|
Parent: | AbstractAdapter |
The PostgreSQL adapter works both with the C-based (www.postgresql.jp/interfaces/ruby/) and the Ruby-base (available both as gem and from rubyforge.org/frs/?group_id=234&release_id=1145) drivers.
Options:
BYTEA_COLUMN_TYPE_OID | = | 17 |
NUMERIC_COLUMN_TYPE_OID | = | 1700 |
TIMESTAMPOID | = | 1114 |
TIMESTAMPTZOID | = | 1184 |
ORDER BY clause for the passed order option.
PostgreSQL does not allow arbitrary ordering when using DISTINCT ON, so we work around this by wrapping the sql as a sub-select and ordering in that query.