pgjson.upsert

pgjson.upsert

CREATE OR REPLACE FUNCTION pgjson.upsert(
    key text,
    data jsonb)
  RETURNS void AS
$BODY$ 
        BEGIN 
            LOOP 
                UPDATE pgjson.main SET doc = data WHERE id = key; 
                IF found THEN 
                    RETURN; 
                END IF; 
                BEGIN 
                    INSERT INTO pgjson.main(id, doc) VALUES (key, data); 
                    RETURN; 
                EXCEPTION WHEN unique_violation THEN 
                END; 
            END LOOP; 
        END; 
        $BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION pgjson.upsert(text, jsonb)
  OWNER TO liyong;