postgres-order-bug.rs

// postgres = "0.11.5"

extern crate postgres;

use postgres::{Connection, SslMode};

fn main() {
    let conn = Connection::connect("postgres://foo:bar@localhost/playground", SslMode::None)
            .unwrap();
    setup_db(&conn);

    let sort = "id DESC";
    for row in &conn.query("SELECT id FROM foo ORDER BY $1", &[&sort]).unwrap() {
        let id: i32 = row.get("id");
        println!("** ORDER BY {}: {}", &sort, id);
    }
}

fn setup_db(conn: &Connection) {
    let _ = conn.execute("CREATE TEMPORARY TABLE foo (id INT PRIMARY KEY)", &[]);
    let _ = conn.execute("INSERT INTO foo VALUES (1)", &[]);
    let _ = conn.execute("INSERT INTO foo VALUES (2)", &[]);
}