store_genesynonym(character varying)

DECLARE

    pgsynonym            ALIAS FOR $1;

​

    pkeyid INTEGER;

  BEGIN

    SELECT INTO pkeyid genesynonym_id

      FROM genesynonym

      WHERE genesynonym.gsynonym = pgsynonym;

    IF NOT FOUND THEN

      INSERT INTO genesynonym 

       (gsynonym)

         VALUES

       (pgsynonym);

      RETURN currval('genesynonym_pk_seq');

    END IF;

    UPDATE genesynonym

      SET

      WHERE

         genesynonym.gsynonym = pgsynonym

​

    RETURN pkeyid;

  END;