store_featureprop(integer, integer, text, integer)

DECLARE

    pfeature_id          ALIAS FOR $1;

    ppkey_id             ALIAS FOR $2;

    ppval                ALIAS FOR $3;

    pprank               ALIAS FOR $4;

​

    pkeyid INTEGER;

  BEGIN

    SELECT INTO pkeyid featureprop_id

      FROM featureprop

      WHERE featureprop.feature_id = pfeature_id AND

            featureprop.pkey_id = ppkey_id AND

            featureprop.pval = ppval AND

            featureprop.prank = pprank;

    IF NOT FOUND THEN

      INSERT INTO featureprop 

       (feature_id, pkey_id, pval, prank)

         VALUES

       (pfeature_id, ppkey_id, ppval, pprank);

      RETURN currval('featureprop_pk_seq');

    END IF;

    UPDATE featureprop

      SET

      WHERE

         featureprop.feature_id = pfeature_id AND

            featureprop.pkey_id = ppkey_id AND

            featureprop.pval = ppval AND

            featureprop.prank = pprank

​

    RETURN pkeyid;

  END;