Function to return id from postgresql query

exec_returning_id.go

package pgsql-helper 

import (
	"database/sql"
	"fmt"
)

//ExecReturningId executes query and returns id. 
// The query must specify what field is returned.
// Example:
//	
//  id, err := ExecReturningId(db, "insert into user(name) values($1) returning id", "Nils Larsgård")
//  log.Printf("Inserted row with id %d with result %v", id, err) 
//
func ExecReturningId(db *sql.DB, query string, args ...interface{}) (int, error) {
	id := -1
	result, err := db.Query(query, args...)
	if err != nil {
		return id, err
	}

	if result.Next() {
		err = result.Scan(&id)
		if err != nil {
			return id, err
		}
		return id, nil
	} else {
		return id, fmt.Errorf("no rows returned from query %q", query)
	}
}