Search Options

Results per page
Sort
Preferred Languages
Advance

Results 1 - 1 of 1 for COALESCE (0.03 sec)

  1. tests/query_test.go

    	}
    
    	// SELECT COALESCE(age,'42') FROM users;
    	r = dryDB.Table("users").Select("COALESCE(age,?)", 42).Find(&User{})
    	if !regexp.MustCompile(`SELECT COALESCE\(age,.*\) FROM .*users.*`).MatchString(r.Statement.SQL.String()) {
    		t.Fatalf("Build Select with func, but got %v", r.Statement.SQL.String())
    	}
    
    	// named arguments
    	r = dryDB.Table("users").Select("COALESCE(age, @default)", sql.Named("default", 42)).Find(&User{})
    Registered: Sun Sep 07 09:35:13 UTC 2025
    - Last Modified: Tue Jul 22 06:21:04 UTC 2025
    - 51K bytes
    - Viewed (0)
Back to top