create or replacefunctionstellenangebote_update_audit_handler ()    returns trigger language plpgsqlas $audit$declare    column_namestext[] := array['refnr','beruf','titel','ort','plz','region','land','lat','lon','arbeitgeber','veroeffentlichungsdatum','modifikationstimestamp','eintrittsdatum','kundennummerhash','externeurl'    ];    ttext :=null;    is_equalboolean;begin     foreach tin array column_names loop        execute format('select ($1).%1$I is not distinct from ($2).%1$I', t)            using old, new into is_equal;        if not is_equal then             execute format('insert into stellenangebote_update_audit''(job_refnr, column_name, old_value, new_value) values''($1,''%1$s'', ($2).%1$I::text, ($3).%1$I::text)', t)                usingold.refnr, old, new;        end if;    end loop;    return new;end $audit$;

createtableif not exists stellenangebote_update_audit (    createdtimestampprimary key defaultcurrent_timestamp,    job_refnrtextnot null,    column_nametextnot null,    old_valuetext,    new_valuetext);createtableif not exists stellenangebote (    refnrvarchar(32)not null,    beruftextnull,    titeltextnull,    orttextnull,    plz ValidPLZnull,    regiontextnull,     landtextnull,    latnumericnull,    lonnumericnull,    arbeitgebertextnull,    veroeffentlichungsdatumdatenull,    modifikationsTimestamptimestampnull,    eintrittsdatumdatenull,    kundennummerHashtextnull,    externeUrltextnull,    createdtimestampnot null defaultcurrent_timestamp,    updatedtimestampnot null defaultcurrent_timestamp,    deletedtimestampnull,    archive_partitionsmallintnot null default0check (archive_partition>=0)) partition by range(archive_partition);