Top "Rails-postgresql" questions

ERROR: function unnest(integer[]) does not exist in postgresql

SELECT UNNEST(ARRAY[1,2,3,4]) While executing the above query I got the error like this: ERROR: function unnest(integer[]) does not …

postgresql rails-postgresql postgresql-9.0 postgresql-8.4

Calendar tables in PostgreSQL 9

I am building an analytics database (I have a firm understanding of the data and the business objectives and only …

database-design postgresql data-warehouse rails-postgresql

Replace NULL values in an array in PostgreSQL

SELECT ARRAY[1,2,3] - ARRAY[5,NULL,6] I am using contrib _int.sql package for array operations in postgresql 8.4 In the above …

arrays postgresql null rails-postgresql

Rails Scope: Select Distinct Title With Values

I'm having trouble with an SQL query in a scope. I need to return a collection of unique Project.titles …

ruby-on-rails ruby-on-rails-3 rails-activerecord rails-postgresql

How to use ActiveRecord outside Rails?

I'm building a Rails application based on hexagonal architecture. One of my adapters is storage adapter (maintained as a gem) …

ruby-on-rails ruby ruby-on-rails-4 activerecord rails-postgresql

How to add sequences to a migration and use them in a model?

I want to have a "Customer" Model with a normal primary key and another column to store a custom "Customer …

ruby-on-rails ruby-on-rails-3.1 rails-migrations rails-models rails-postgresql