Simple postgres array parsing in Go.

pq-array.go

package main

import (
	"database/sql"
	"fmt"
	_ "github.com/bmizerany/pq"
	"strconv"
	"strings"
)

func main() {
	// Assuming: create table data(vals numeric[]);
	db, err := sql.Open("postgres", "user=ryandotsmith dbname=test sslmode=disable")
	db.Exec("insert into data values('{32.0, 49}')")
	rows, err := db.Query("SELECT vals from data")
	if err != nil {
		fmt.Printf("error=%s\n", err)
		return
	}
	for rows.Next() {
		var x []byte
		rows.Scan(&x)
		// pq returns something like: {1.0, 2.0}
		// let us remove the { and the }
		trimed := x[1 : len(x)-1]
		// Assuming the numbers are seperated by commas.
		numbers := strings.Split(string(trimed), ",")
		// Showing that we can do cool things with floats.
		var sum float64
		for _, x := range numbers {
			f, err := strconv.ParseFloat(x, 64)
			if err == nil {
				sum += f
			}
		}
		fmt.Printf("sum=%f\n", sum)
	}
}