Skip to content

Instantly share code, notes, and snippets.

Avatar

luiszacheu

  • Santander Tecnologia
  • São Paulo, Brazil
View GitHub Profile
@erikhenrique
erikhenrique / bin-cc.md
Last active Nov 21, 2022
Bin de cartões de crédito para validação
View bin-cc.md

Validação para cartão de crédito.

Bin e padrões para validação de cartão de crédito.

Bandeira Começa com Máximo de número Máximo de número cvc
Visa 4 13,16 3
Mastercard 5 16 3
@carlzulauf
carlzulauf / haversine.sql
Created Feb 2, 2012
PostgreSQL function for haversine distance calculation, in miles
View haversine.sql
-- Haversine Formula based geodistance in miles (constant is diameter of Earth in miles)
-- Based on a similar PostgreSQL function found here: https://gist.github.com/831833
-- Updated to use distance formulas found here: http://www.codecodex.com/wiki/Calculate_distance_between_two_points_on_a_globe
CREATE OR REPLACE FUNCTION public.geodistance(alat double precision, alng double precision, blat double precision, blng double precision)
RETURNS double precision AS
$BODY$
SELECT asin(
sqrt(
sin(radians($3-$1)/2)^2 +
sin(radians($4-$2)/2)^2 *