informix to postgres: WITH (NOT VARIANT) unhandled

[strk]

An Informix function like this:

CREATE FUNCTION crs_upperAnsi(avc VARCHAR(255) )
RETURNING VARCHAR(255) AS normalised
WITH (NOT VARIANT);
    -- Call function for macron and case insensitive functional indexes
    RETURN cf_ccl_upperAnsi(avc);
END FUNCTION;

Gets converted to this broken PostgreSQL code:

CREATE OR REPLACE FUNCTION crs_upperAnsi(avc VARCHAR(255) )
RETURNS VARCHAR(255) AS $$

BEGIN
WITH (NOT VARIANT);
    -- Call function for macron and case insensitive functional indexes
    RETURN cf_ccl_upperAnsi(avc);
END;
$$ LANGUAGE plpgsql;

See the WITH (NOT VARIANT) part, which makes PostgreSQL choke. Things work fine by removing that line.

[strk]

Ok I think WITH (NOT VARIANT) needs to be translated to IMMUTABLE as a parameter of PostgreSQL function.

[strk]

Pull request #24 deals with this problem, fixing it for the specific case (can probably be generalized further)