sfackler/rust-postgres-array

rust-postgres-array

Documentation

Support for PostgreSQL arrays in rust-postgres.

rust-postgres-array's Issues

not working with latest rust

postgres_array-0.1.1/src/impls/mod.rs:13:8: 13:21 error: `$expected:pat` is followed by `|`, which is not allowed for `pat` fragments
postgres_array-0.1.1/src/impls/mod.rs:13     ($($expected:pat)|+, $actual:ident) => (

postgres_array-0.1.1/src/impls/mod.rs:22:8: 22:16 error: `$oid:pat` is followed by `|`, which is not allowed for `pat` fragments
postgres_array-0.1.1/src/impls/mod.rs:22     ($($oid:pat)|+, $t:ty) => {

postgres_array-0.1.1/src/impls/mod.rs:48:8: 48:16 error: `$oid:pat` is followed by `|`, which is not allowed for `pat` fragments
postgres_array-0.1.1/src/impls/mod.rs:48     ($($oid:pat)|+, $t:ty) => {

Empty rows

I think the following behaviour is unintended.

let _ = conn.execute("ALTER TABLE table ADD COLUMN column int4[] DEFAULT '{}'",&[]);
let stmt = conn.prepare("SELECT column FROM table").unwrap();
for row in stmt.query(&[]).unwrap() {
     //row.result_descriptions() is &[(column, Int4Array)]
    let _:ArrayBase<Option<i32>> =row.get(0u); // panics at error retrieving column 0: end of file', src/lib.rs:1552
}

Array of Uuid Values

Seemingly this does not currently support an array of Uuid values is that correct?

Usage documentation

Please write a couple of lines of documentation & examples, it's not very clear how to use the library.

upgrade this crate to latest

It seems that this crate isn't compatible with latest postgres (tokio). Would you mind updating?

How to parse from string?

Is there a way to use this crate to parse the string result back into an array of values?

I'm currently using the sqlparser crate to do it but wondering if there is an easier way.

fn hs_decode(val: &str) -> Option<HashSet<String>> {
    let ast = sqlparser::tokenizer::Tokenizer::new(&GenericDialect, val)
        .tokenize()
        .ok()?;

    let results = sqlparser::parser::Parser::new(ast, &GenericDialect)
        .parse_identifiers()
        .ok()?;

    Some(results.iter().map(|x| x.value.clone()).collect())
}