Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

LIMIT ALL query on bind parameter support #930

Open
oniharnantyo123 opened this issue Jan 6, 2020 · 1 comment
Open

LIMIT ALL query on bind parameter support #930

oniharnantyo123 opened this issue Jan 6, 2020 · 1 comment

Comments

@oniharnantyo123
Copy link

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
Copy link
Contributor

cbandy commented Jan 6, 2020

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants