Skip to content

Instantly share code, notes, and snippets.

@tygern

tygern/create_function.sql

Created August 26, 2015 13:17
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save tygern/3c3f68818a5aa73ed602 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save tygern/3c3f68818a5aa73ed602 to your computer and use it in GitHub Desktop.
Download ZIP
Non Sequential ID Generation - create function
Raw
create_function.sql
CREATE FUNCTION fetch_id(text) RETURNS bigint AS
'select (9369712273 * nextval($1) + 1365089121) % 999999937;'
LANGUAGE SQL
IMMUTABLE
RETURNS NULL ON NULL INPUT;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment