Skip to content

Instantly share code, notes, and snippets.

@fdr
fdr / experiment.sql
Created August 17, 2011 04:17
plv8 experiments and microbenchmarks
BEGIN;
-- plv8: http://code.google.com/p/plv8js/
CREATE OR REPLACE LANGUAGE plv8;
-- Create a function that grabs a passed key and coerces to bigint.
CREATE OR REPLACE FUNCTION plv8_project_key(key text, json_raw text)
RETURNS bigint AS $$
// This is javascript!
var o = JSON.parse(json_raw);
return o[key];