Syntax error at end of input in PostgreSQL

by

You haven’t provided any details about the language/environment, but I’ll try a wild guess anyway:

MySQL’s prepared statements natively use ? as the parameter placeholder, but PostgreSQL uses $1, $2 etc. Try replacing the ? with $1 and see if it works:

WHERE address = $1

The error messages in PostgreSQL are very cryptic.

In general, I’ve found that Postgres error messages are better than competing products (ahem, MySQL and especially Oracle), but in this instance you’ve managed to confuse the parser beyond sanity. 🙂

More Related Contents:

  1. Go and IN clause in Postgres
  2. How do I handle opening/closing Db connection in a Go app?
  3. How to reset postgres’ primary key sequence when it falls out of sync?
  4. Calculating and saving space in PostgreSQL
  5. The forgotten assignment operator “=” and the commonplace “:=”
  6. Passing user id to PostgreSQL triggers
  7. Do nullable columns occupy additional space in PostgreSQL?
  8. how to emulate “insert ignore” and “on duplicate key update” (sql merge) with postgresql?
  9. How do I efficiently select the previous non-null value?
  10. Postgresql : Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections [duplicate]
  11. Dynamic SQL (EXECUTE) as condition for IF statement
  12. Disable PostgreSQL foreign key checks for migrations
  13. uWSGI, Flask, sqlalchemy, and postgres: SSL error: decryption failed or bad record mac
  14. Prevent recursive trigger in PostgreSQL
  15. serial in postgres is being increased even though I added on conflict do nothing
  16. Can’t connect to Postgresql on port 5432
  17. Spark Dataframes UPSERT to Postgres Table
  18. PostgreSQL Error: Relation already exists
  19. How to make a select with array contains value clause in psql
  20. Using row_to_json() with nested joins
  21. Optimize Postgres query on timestamp range
  22. Sorting array elements
  23. pgAdmin III Why query results are shortened?
  24. How do I alter the date format in Postgres?
  25. OpenShift: How to connect to postgresql from my PC
  26. clojure.java.jdbc lazy query
  27. Reset PostgreSQL primary key to 1
  28. Setting application_name on Postgres/SQLAlchemy
  29. How to fix pg_dump version mismatch errors?
  30. plpgsql error “RETURN NEXT cannot have a parameter in function with OUT parameters” in table-returning function

Leave a Comment