How to implement simple COUNT(*)

[owentran]

The db.Query and db.QueryOne expects a struct to populate. For a simple select count(*) query, what would you recommend?

My attempt:

type QueryResult struct {
    Count int
}

qr := QueryResult{}
_, err := db.QueryOne(&qr, `SELECT COUNT(*) FROM users`)
if err == nil {
   return qr.Count, nil
}
return -1, err

Is there a more idiomatic way to do this? Thanks.

[vmihailenco]

Check http://godoc.org/gopkg.in/pg.v3#example-LoadInto

var count int
db.QueryOne(pg.LoadInto(&count), `SELECT COUNT(*) FROM users`)