How to call a function with array params

[kokteyldev]

I have a function for batch insert, which has array parameters like so:

insert_batch(_dates date[], _values integer[])

I am trying to call it like the following:

SELECT * FROM insert_batch($1, $2)

I read through the souce code however I couldn't find a way I can do this. Is it possible to call raw select sql with bind parameters.

[vmihailenco]

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...

[vmihailenco]

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

[drt24]

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

[vmihailenco]

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

[vmihailenco]

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.

[vmihailenco]

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.