dbkbali dbkbali

dbkbali / AXH_Vector_Sum.sql

Created January 15, 2018 05:12 — forked from andrewxhill/AXH_Vector_Sum.sql

Sum PostgreSQL arrays in place [1,2,3] + [2,3,4] = [3,5,7]

	CREATE AGGREGATE vector_sum (
	sfunc = AXH_Vector_Sum,
	basetype = int[],
	stype = int[],
	initcond = '{0}'
	);

	DROP FUNCTION IF EXISTS AXH_Vector_Sum(int[], int[]);
	CREATE OR REPLACE FUNCTION AXH_Vector_Sum(int[], int[])
	RETURNS int[] AS $$

dbkbali / AXH_Vector_Sum.sql

Created January 15, 2018 05:12 — forked from andrewxhill/AXH_Vector_Sum.sql

Sum PostgreSQL arrays in place [1,2,3] + [2,3,4] = [3,5,7]

	CREATE AGGREGATE vector_sum (
	sfunc = AXH_Vector_Sum,
	basetype = int[],
	stype = int[],
	initcond = '{0}'
	);

	DROP FUNCTION IF EXISTS AXH_Vector_Sum(int[], int[]);
	CREATE OR REPLACE FUNCTION AXH_Vector_Sum(int[], int[])
	RETURNS int[] AS $$

dbkbali / myzshtheme

Created May 17, 2019 03:49

	# If you come from bash you might have to change your $PATH.
	# export PATH=$HOME/bin:/usr/local/bin:$PATH
	source ~/perl5/perlbrew/etc/bashrc
	export TERM="xterm-256color"
	PS1='[\u@\h \W$(__docker_machine_ps1)]\$ '
	[ -n "$PS1" ]

	export PATH="$HOME/.yarn/bin:$HOME/.config/yarn/global/node_modules/.bin:$PATH"
	PATH="/Library/Frameworks/Python.framework/Versions/3.6/bin:/usr/X11/bin:/Applications/Postgres.app/Contents/Versions/latest/bin:/usr/local/bin/mysql:${PATH}"
	export PATH=/usr/local/bin:/usr/local/sbin:$PATH