numpy_plpythonu--1.0.sql

-- complain if script is sourced in psql, rather than via CREATE EXTENSION
\echo Use "CREATE EXTENSION jsonb_plpythonu" to load this file. \quit

CREATE FUNCTION numpy_to_plpython(val internal) RETURNS internal LANGUAGE C STRICT IMMUTABLE
AS 'MODULE_PATHNAME', 'numpy_to_plpython';

CREATE FUNCTION plpython_to_numpy(val internal) RETURNS real[] LANGUAGE C STRICT IMMUTABLE
AS 'MODULE_PATHNAME', 'plpython_to_numpy';

CREATE TRANSFORM FOR real[] LANGUAGE plpythonu (
    FROM SQL WITH FUNCTION numpy_to_plpython(internal),
    TO SQL WITH FUNCTION plpython_to_numpy(internal)
);

--COMMENT ON TRANSFORM FOR real[] LANGUAGE plpythonu IS 'transform between numpy and Python';