Function pgNumberFormatToDuckDB

transpiler/transform/functions.go:635–667

pgNumberFormatToDuckDB converts PostgreSQL number format specifiers to DuckDB format() syntax. PG format: '999,999.99' → DuckDB: '{:,.2f}'

(pgFormat string)

// pgNumberFormatToDuckDB converts PostgreSQL number format specifiers to DuckDB format() syntax.
// PG format: '999,999.99' → DuckDB: '{:,.2f}'
func pgNumberFormatToDuckDB(pgFormat string) string {
	upper := strings.ToUpper(strings.ReplaceAll(strings.ReplaceAll(pgFormat, "FM", ""), "fm", ""))

	hasComma := strings.ContainsAny(upper, ",G")

	// Count decimal places (digits after . or D)
	decimalPlaces := 0
	dotIdx := strings.IndexAny(upper, ".D")
	if dotIdx >= 0 {
		for i := dotIdx + 1; i < len(upper); i++ {
			if upper[i] == '9' || upper[i] == '0' {
				decimalPlaces++
			}
		}
	}

	commaFlag := ""
	if hasComma {
		commaFlag = ","
	}

	prefix := ""
	if strings.Contains(upper, "$") || strings.Contains(upper, "L") {
		prefix = "$"
	}

	// Check for EEEE (scientific notation)
	if strings.Contains(upper, "EEEE") {
		return fmt.Sprintf("%s{:%s.%de}", prefix, commaFlag, decimalPlaces)
	}

	return fmt.Sprintf("%s{:%s.%df}", prefix, commaFlag, decimalPlaces)
}