How to call a function with array params about pg HOT 6 CLOSED

With pg.v4 you can try something like:

ints := []int{1, 2, 3}
db.Exec(`SELECT * FROM insert_batch(?)`, types.Array(ints))

But array of time types.Array([]time.Time{...}) is not supported...

from pg.

Overall array support is very limited right now - https://github.com/go-pg/pg/blob/v4/types/array.go#L16-L28

from pg.

Actually the example needs curly brackets rather than round brackets:

ints := []int{1, 2, 3}
db.Exec("SELECT * FROM insert_batch(?)", types.Array{ints})

Otherwise you get:

cannot convert ints (type []int) to type types.Array

from pg.

Eventually I will make it work correctly, but first I want to stabilize v4 branch and release ORM to public...

from pg.

FYI #138 added support for []time.Time array, but API changed slightly:

ints := []int{1, 2, 3}
times := []time.TIme{time.Now()}
db.Exec(`SELECT * FROM insert_batch(?, ?)`, pg.Array(&ints), pg.Array(&times))

There is still some work to be done, but it should be usable.

from pg.

I consider array support finished. See https://godoc.org/gopkg.in/pg.v4#example-DB-Model-PostgresqlArrayStructTag and https://godoc.org/gopkg.in/pg.v4#example-Array for examples.

from pg.