Function normalizePostgreSQLFunction

backend/plugin/schema/differ.go:2229–2269

normalizePostgreSQLFunction normalizes PostgreSQL function definitions for comparison

(definition string)

// normalizePostgreSQLFunction normalizes PostgreSQL function definitions for comparison
func normalizePostgreSQLFunction(definition string) string {
	if definition == "" {
		return ""
	}

	normalized := strings.ToLower(definition)

	// Normalize whitespace
	normalized = strings.ReplaceAll(normalized, "\n", " ")
	normalized = strings.ReplaceAll(normalized, "\t", " ")

	// Remove extra spaces
	for strings.Contains(normalized, "  ") {
		normalized = strings.ReplaceAll(normalized, "  ", " ")
	}

	// Normalize CREATE vs CREATE OR REPLACE
	normalized = strings.ReplaceAll(normalized, "create or replace function", "create function")
	normalized = strings.ReplaceAll(normalized, "create or replace procedure", "create procedure")

	// Remove public schema prefix from function and procedure names
	normalized = strings.ReplaceAll(normalized, "function public.", "function ")
	normalized = strings.ReplaceAll(normalized, "procedure public.", "procedure ")

	// Normalize parameter types
	normalized = strings.ReplaceAll(normalized, "character varying", "varchar")
	normalized = strings.ReplaceAll(normalized, "returns numeric", "returns decimal")

	// Normalize dollar quoting - handle various dollar quote formats
	normalized = strings.ReplaceAll(normalized, "$function$", "$$")
	normalized = strings.ReplaceAll(normalized, "$procedure$", "$$")

	// Normalize language position - move to end
	if strings.Contains(normalized, "language plpgsql") && !strings.HasSuffix(strings.TrimSpace(normalized), "language plpgsql") {
		withoutLanguage := strings.ReplaceAll(normalized, " language plpgsql", "")
		withoutLanguage = strings.ReplaceAll(withoutLanguage, "language plpgsql ", "")
		normalized = strings.TrimSpace(withoutLanguage) + " language plpgsql"
	}

	return strings.TrimSpace(normalized)
}

// normalizePostgreSQLCheckConstraint normalizes PostgreSQL check constraint expressions for comparison
func normalizePostgreSQLCheckConstraint(expression string) string {