Unnamed
public text v1 · immutable v_query := 'INSERT INTO ps.tbl_psearch_' || v_partition ||
'(pse_id, pse_uid, pse_nt, pse_type, pse_last) VALUES ' ||
'(' ||
COALESCE(quote_literal(NEW.pse_id), 'NULL') || ',' ||
COALESCE(quote_literal(NEW.pse_uid), 'NULL') || ',' ||
COALESCE(quote_literal(NEW.pse_nt), 'NULL') || ',' ||
COALESCE(quote_literal(NEW.pse_type), 'NULL') || ',' ||
COALESCE(quote_literal(NEW.pse_last), 'NULL') ||
')';
EXECUTE v_query;