search for: array_accum

Hello! I am trying to figure out how to implement *logical deletes* instead of physical deletes using ActiveRecord. Basically, in many applications that deal with E-Commerce, you really can''t physically delete almost anything, because records must be kept for auditing and customer service tracking purposes. In the past, I''ve implemented logical deletes as follows: 1.

...| Type | Modifiers -------------+-----------------------+----------- code | character varying(10) | description | text | folds | integer[] | View definition: SELECT flashings.code, max(flashings.description::text) AS description, array_accum(flashings.folds) AS folds FROM flashings GROUP BY flashings.code; Here is a sample of the records. select * from flashing_codes limit 10; code | description | folds ----------+------------------------------------------+--------------------- SG.0...