Skip to content

Instantly share code, notes, and snippets.

View jay-dee7's full-sized avatar
🦀
Bite me

Jasdeep Singh jay-dee7

🦀
Bite me
View GitHub Profile
@jay-dee7
jay-dee7 / pg-uuid-v7.sql
Created September 17, 2022 12:23
PostgreSQL UUID V7 function
create extension if not exists pgcrypto;
create or replace function uuid_generate_v7()
returns uuid
as $$
declare
ver_rand_var bytea = e'\\000\\000\\000';
unix_time_ms bytea;
rand_bytes bytea;
begin
### Keybase proof
I hereby claim:
* I am jay-dee7 on github.
* I am jasdeepsingh (https://keybase.io/jasdeepsingh) on keybase.
* I have a public key ASC09rpN-uzc31CsVPD9HNvFVTlyiAjB2BTCG_Ld5uF0EQo
To claim this, I am signing this object:
// Setup
function phoneticLookup(val) {
var result = "";
// Only change code below this line
var lookup = {
"alpha":"Adams",
"bravo":"Boston",
"charlie":"Chicago",
"delta":"Denver",