Skip to content

Instantly share code, notes, and snippets.

@mhkeller

mhkeller/rando.sql

Last active October 17, 2018 20:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mhkeller/1ed0838e66ae9be6e44fe9e4c64c1d5f to your computer and use it in GitHub Desktop.
Save mhkeller/1ed0838e66ae9be6e44fe9e4c64c1d5f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
rando.sql
CREATE OR REPLACE FUNCTION rando(anyarray) RETURNS any AS $BODY$
SELECT unnest($1::anyarray ORDER BY RANDOM()) LIMIT 1
$BODY$
LANGUAGE SQL;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment