| -- Adjust the following if this is not the schema you installed into |
| \set ORA_SCHEMA oracompat |
| set search_path = :ORA_SCHEMA, pg_catalog; |
| |
| BEGIN; |
| DROP FUNCTION IF EXISTS nvl(anyelement, anyelement); |
| |
| DROP FUNCTION IF EXISTS add_months(day date, value int); |
| |
| DROP FUNCTION IF EXISTS last_day(value date); |
| |
| DROP FUNCTION IF EXISTS next_day(value date, weekday text); |
| DROP FUNCTION IF EXISTS next_day(value date, weekday integer); |
| |
| DROP FUNCTION IF EXISTS months_between(date1 date, date2 date); |
| |
| DROP FUNCTION IF EXISTS trunc(value date, fmt text); |
| DROP FUNCTION IF EXISTS trunc(value timestamp with time zone, fmt text); |
| DROP FUNCTION IF EXISTS trunc(value timestamp with time zone); |
| DROP FUNCTION IF EXISTS trunc(value date); |
| |
| DROP FUNCTION IF EXISTS round(value timestamp with time zone, fmt text); |
| DROP FUNCTION IF EXISTS round(value timestamp with time zone); |
| DROP FUNCTION IF EXISTS round(value date); |
| DROP FUNCTION IF EXISTS round(value date, fmt text); |
| |
| DROP FUNCTION IF EXISTS instr(str text, patt text, start int, nth int); |
| DROP FUNCTION IF EXISTS instr(str text, patt text, start int); |
| DROP FUNCTION IF EXISTS instr(str text, patt text); |
| |
| DROP FUNCTION IF EXISTS reverse(text, int, int); |
| DROP FUNCTION IF EXISTS reverse(text, int); |
| DROP FUNCTION IF EXISTS reverse(text); |
| |
| DROP FUNCTION IF EXISTS concat(text, text); |
| DROP FUNCTION IF EXISTS concat(anyarray, text); |
| DROP FUNCTION IF EXISTS concat(text, anyarray); |
| DROP FUNCTION IF EXISTS concat(anyarray, anyarray); |
| |
| DROP FUNCTION IF EXISTS nanvl(float4, float4); |
| DROP FUNCTION IF EXISTS nanvl(float8, float8); |
| DROP FUNCTION IF EXISTS nanvl(numeric, numeric); |
| |
| DROP FUNCTION IF EXISTS bitand(bigint, bigint); |
| |
| DROP FUNCTION IF EXISTS listagg1_transfn(text, text); |
| DROP FUNCTION IF EXISTS listagg2_transfn(text, text, text); |
| |
| DROP FUNCTION IF EXISTS nvl2(anyelement, anyelement, anyelement); |
| |
| DROP FUNCTION IF EXISTS lnnvl(bool); |
| |
| DROP FUNCTION IF EXISTS dump("any"); |
| DROP FUNCTION IF EXISTS dump("any", integer); |
| |
| DROP FUNCTION IF EXISTS nlssort(text, text); |
| |
| DROP FUNCTION IF EXISTS substr(text, int, int); |
| DROP FUNCTION IF EXISTS substr(text, int); |
| |
| COMMIT; |