numpy_plpython3u--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_plpython3(val internal) RETURNS internal LANGUAGE C STRICT IMMUTABLE
AS 'MODULE_PATHNAME', 'numpy_to_plpython';

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

CREATE TRANSFORM FOR real[] LANGUAGE plpython3u (
    FROM SQL WITH FUNCTION numpy_to_plpython3(internal),
    TO SQL WITH FUNCTION plpython3_to_numpy(internal)
);

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