Skip to content

unsupported type []interface {}, a slice #57

Open

Description

@denwwer

Hi, I have issue with

// EnableInterpolation = true
data := []interface{}{1,"hello", true} // some data
db.Exec("INSERT INTO table (a, b, c) VALUES ($1, $2, $3)", data)
=> err: sql: converting Exec argument #0's type: unsupported type []interface {}, a slice

using driver github.com/jackc/pgx/stdlib, package gopkg.in/mgutz/dat.v2/dat
maybe someone was had this error, so can help me. Also it will be cool func .Values() to can handle slice

Activity

  1. mgutz commented on Feb 6, 2017

    @mgutz
    Owner

    First, I can't guarantee anything works with pgx/stdlib. I made a separate runner for it and found it to actually be slower with my test cases and discontinued supporting it.

    Need to use spread operator, otherwise dat treats that as a single value

    res, err := DB.SQL("INSERT INTO table (a, b, c) VALUES ($1, $2, $3)", data...).Exec()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions