LIMIT ALL query on bind parameter support

lib / pq

Pure Go Postgres driver for database/sql

https://pkg.go.dev/github.com/lib/pq

MIT License

9.01k stars 910 forks source link

LIMIT ALL query on bind parameter support #930

Open oniharnantyo123 opened 4 years ago

oniharnantyo123 commented 4 years ago

Hello... I have tried a query to get all data with ALL query on sql but seems like pq doesn't support that query on bind parameter. Query : .... LIMIT $1 OFFSET $2

rows, err := db.QueryContext(ctx, query, "ALL", 0)

i got this error : pq: error in argument for $1: strconv.ParseInt: parsing \"ALL\": invalid syntax"

will pq support feature to bind "ALL" to parameter ?

cbandy commented 4 years ago

Try nil.

https://www.postgresql.org/docs/current/sql-select.html#SQL-LIMIT