Placeholders for OFFSET or LIMIT are not supported

[linuxerwang]

This gives error:

    rows, err := db.Query("SELECT * FROM a LIMIT ? OFFSET ?", 100, 2)

2013/10/20 11:08:32 error querying database: pq: syntax error at or near "OFFSET"
2013/10/20 11:08:32 http: panic serving 127.0.0.1:39992: runtime error: invalid memory address or nil pointer dereference

This works fine:

    rows, err := db.Query("SELECT * FROM a LIMIT 100 OFFSET 2")

According to the doc in database/sql, "The args are for any placeholder parameters in the query." So I think LIMIT/OFFSET should also be supported.

[johto]

What happens if you use PostgreSQL native $n syntax for the placeholders? See the example here: http://godoc.org/github.com/lib/pq

[linuxerwang]

$n works fine. Thanks!

But I still think that ? should also be supported since it's the go standard.

[kisielk]

There is no standard for placeholders in Go, it depends on the database driver. Currently pq passes the query directly to Postgres, which doesn't support the ? placeholders.

[Lewiscowles1986]

TLDR; pq is stupid