ryanguill
/ postgres-merge-arrays.sql
Created
December 21, 2016 16:41
in postgres, there currently isnt a function to combine two arrays and remove duplicates - this will do that.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE OR REPLACE FUNCTION mergeArrays (a1 ANYARRAY, a2 ANYARRAY) RETURNS ANYARRAY AS $$ | |
| SELECT ARRAY_AGG(x ORDER BY x) | |
| FROM ( | |
| SELECT DISTINCT UNNEST($1 || $2) AS x | |
| ) s; | |
| $$ LANGUAGE SQL STRICT; |
json2d
/ state-arg-reselect.js
Last active
February 9, 2020 03:56
proposal to put state into callback scope through 'this'
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| const entryByIdSelector = (state) => state.todos.entrybyId | |
| const recentIdsSelector = (state) => state.todos.recentIds | |
| const entrySelector = _.memoize( | |
| (id) => createSelector( | |
| entryByIdSelector, | |
| (entryById) => entryById[id] | |
| ) | |
| ) | |