Function is_datetime_function_result

src/cache/enhanced_statement_pool.rs:453–477

Helper function to detect if a column result is from a PostgreSQL datetime function

(query: &str, column_name: &str)

/// Helper function to detect if a column result is from a PostgreSQL datetime function
fn is_datetime_function_result(query: &str, column_name: &str) -> bool {
    let query_upper = query.to_uppercase();
    let column_upper = column_name.to_uppercase();
    
    // Check for NOW() function
    if query_upper.contains("NOW()") && (column_upper == "NOW" || column_upper == "NOW()") {
        return true;
    }
    
    // Check for CURRENT_TIMESTAMP function
    if query_upper.contains("CURRENT_TIMESTAMP") && (column_upper == "CURRENT_TIMESTAMP" || column_upper == "CURRENT_TIMESTAMP()") {
        return true;
    }
    
    // Check for aliased datetime functions like "SELECT NOW() as now"
    if query_upper.contains("NOW()") && query_upper.contains(&format!("AS {column_upper}")) {
        return true;
    }
    
    if query_upper.contains("CURRENT_TIMESTAMP") && query_upper.contains(&format!("AS {column_upper}")) {
        return true;
    }
    
    false
}

#[cfg(test)]
mod tests {