inconsistent return value from pg_stat_database datname column.

[james-lawrence]

func main() {
    // using string returns a string as expected.
    // var datname string
    // using interface{} returns a []byte
    var datname interface{}

    // db, err := sql.Open("postgres", "postgres://user:password@host:5432/database?sslmode=disable")
    if err != nil {
        log.Fatalln(err)
    }
    row := db.QueryRow("SELECT datname::text FROM pg_stat_database LIMIT 1")
    err = row.Scan(&datname)

    log.Println("datname", datname, err)
}

returns a []byte when an interface{} is provided, correctly returns a string when a string is provided. It should be consistently a string.

[cbandy]

Are you using a recent version of this package? I believe text type has been returned as string since #436.

[freeformz]

This works fine for me with master.

[james-lawrence]

i was likely on an old version at a time. closing works for me with latest as well. my bad.