Module: ColumnQueries::PostgreSQLAdapterExtensions

Defined in:
lib/column_queries/postgresql_adapter_extensions.rb

Instance Method Summary collapse

Instance Method Details

#select_columns_as_int_arrays(sql) ⇒ Object

column_values is quite fast method written in C provided by pg gem which seems like what we need for fetching lenghty id arrays



8
9
10
11
 
# File 'lib/column_queries/postgresql_adapter_extensions.rb', line 8

def select_columns_as_int_arrays(sql)
  result = execute(sql)
  (0...result.nfields).collect {|i| result.column_values(i).map {|j| j.to_i}}
end

#select_int_values(sql) ⇒ Object 



2
3
4
 
# File 'lib/column_queries/postgresql_adapter_extensions.rb', line 2

def select_int_values(sql)
  select_columns_as_int_arrays(sql).first
end