-- Name: _toPlacerank(); Type: FUNCTION; Schema: public; Owner: -

--

CREATE FUNCTION "_toPlacerank"() RETURNS trigger

    LANGUAGE plpgsql IMMUTABLE

    AS $$

BEGIN

    new.result := CAST(new.value AS placerank);

    RETURN new;

END;

$$;

--

-- Name: _toPlacerank; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE "_toPlacerank" (

    result placerank,

    value text

);

--

-- Name: _toPlacerank_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE UNIQUE INDEX "_toPlacerank_unique" ON "_toPlacerank" USING btree ((COALESCE(value, '\\N'::text)));

--

-- Name: _toPlacerank; Type: TRIGGER; Schema: public; Owner: -

--

CREATE TRIGGER "_toPlacerank" BEFORE INSERT OR UPDATE ON "_toPlacerank" FOR EACH ROW EXECUTE PROCEDURE "_toPlacerank"();

--