0.03
No commit activity in last 3 years
No release in over 3 years
ar_pg_array includes support of PostgreSQL's int[], float[], text[], timestamptz[] etc. into ActiveRecord. You could define migrations for array columns, query on array columns.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
 Dependencies

Runtime

< 4.0, >= 3.0.6
 Project Readme

PostgresArrays

This library adds ability to use PostgreSQL array types with ActiveRecord.

> User.find(:all, :conditions=>['arr @> ?', [1,2,3].pg])
  SELECT * FROM "users" WHERE ('arr' @> E'{"1", "2", "3"}')
> User.find(:all, :conditions=>['arr @> ?', [1,2,3].pg(:integer)])
  SELECT * FROM "users" WHERE (arr @> '{1,2,3}')
> User.find(:all, :conditions=>['arr @> ?', [1,2,3].pg(:float)])
  SELECT * FROM "users" WHERE (arr @> '{1.0,2.0,3.0}')
> u = User.find(1)
  SELECT * FROM "users" WHERE ("users"."id" = 1)
  => #<User id: 1, ..., arr: [1,2]>
> u.arr = [3,4]
> u.save
  UPDATE "users" SET "db_ar" = '{3.0,4.0}' WHERE "id" = 19
> User.find(:all, :conditions=>{:arr=>[3,4].pg})
  SELECT * FROM "users" WHERE ("users"."arr" = E'{"3", "4"}')
> User.find(:all, :conditions=>{:arr=>[3,4].search_any(:float)})
  SELECT * FROM "users" WHERE ("users"."arr" && '{3.0,4.0}')
> User.find(:all, :conditions=>{:arr=>[3,4].search_all(:integer)})
  SELECT * FROM "users" WHERE ("users"."arr" @> '{3,4}')
> User.find(:all, :conditions=>{:arr=>[3,4].search_subarray(:safe)})
  SELECT * FROM "users" WHERE ("users"."arr" <@ '{3,4}')
  
  class U < ActiveRecord::Migration
    def self.up
      create_table :users do |t|
        t.integer_array :int_ar
      end
      add_column :users, :fl_ar, :float_array
    end
  end

Installation

gem install ar_pg_array

Changelog

0.9.13

Since version 0.9.13 ar_pg_array will try to detect arrays changed inplace.
And parsed arrays are now cached in @attributes_cache.
Thanks to Romain Beauxis (https://github.com/toots ) for being insistent about this.

Copyright (c) 2010 Sokolov Yura aka funny_falcon, released under the MIT license