Troubleshooting of PostgreSQL

From LemonWiki共筆
Jump to navigation Jump to search

Troubleshooting of PostgreSQL

Syntax error: 7 ERROR: LIMIT #,# syntax is not supported[edit]

Query syntax mer error

SELECT * 
FROM my_table
LIMIT 0,10

Error message

Uncaught PDOException: SQLSTATE[42601]: Syntax error: 7 ERROR:  LIMIT #,# syntax is not supported                                                         
HINT:  Use separate LIMIT and OFFSET clauses.

Correct query syntax

SELECT * 
FROM my_table
LIMIT 10 OFFSET 0

References

ERROR: argument of WHERE must be type boolean, not type integer[edit]

Query syntax mer error

SELECT * 
FROM my_table
WHERE 1

Correct query syntax

SELECT * 
FROM my_table
WHERE 1 = 1

or

SELECT * 
FROM my_table
WHERE TRUE

References

The numeric column data all became null after imported[edit]

Troubleshooting of Navicat for PostgreSQL


Troubleshooting of ...

Template