field

gistfile1.sql

-- Function: field(anyelement, anyarray)

-- DROP FUNCTION field(anyelement, anyarray);

CREATE OR REPLACE FUNCTION field(anyelement, anyarray)
  RETURNS integer AS
$BODY$
  SELECT
    COALESCE((SELECT i
              FROM generate_series(1, array_upper($2, 1)) gs(i)
              WHERE $2[i] = $1),
             0);
$BODY$
  LANGUAGE sql STABLE
  COST 100;
ALTER FUNCTION field(anyelement, anyarray)
  OWNER TO root;