Troubleshooting of PostgreSQL

From LemonWiki共筆
Revision as of 20:43, 11 October 2022 by Unknown user (talk) (Created page with "Troubleshooting of PostgreSQL == Syntax error: 7 ERROR: LIMIT #,# syntax is not supported == Query syntax mer error <pre> SELECT * FROM my_table LIMIT 0,10 </pre> Correct...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Troubleshooting of PostgreSQL

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

Query syntax mer error 

SELECT * 
FROM my_table
LIMIT 0,10

Correct query syntax 

SELECT * 
FROM my_table
LIMIT 10 OFFSET 0
Retrieved from "https://wiki.planetoid.info/index.php?title=Troubleshooting_of_PostgreSQL&oldid=23267"