By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,988 Members | 1,367 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,988 IT Pros & Developers. It's quick & easy.

syntax is not supported error

P: 37
HI team,

I was trying to run the following code and got the below error. Can someone inform me why this is such? I'm using Postgres 7.2. Any workaround to make this script work? Thanks!

Expand|Select|Wrap|Line Numbers
  1. SELECT * FROM menu LIMIT 0, 10
  2.  
error:
LIMIT #,# syntax is not supported
Jun 19 '07 #1
Share this Question
Share on Google+
1 Reply


P: 37
HI team,

I was trying to run the following code and got the below error. Can someone inform me why this is such? I'm using Postgres 7.2. Any workaround to make this script work? Thanks!

Expand|Select|Wrap|Line Numbers
  1. SELECT * FROM menu LIMIT 0, 10
  2.  
error:
LIMIT #,# syntax is not supported
I fortunately found the reason for my problem. I got the syntax incorrect. It should be

Expand|Select|Wrap|Line Numbers
  1. SELECT * FROM menu OFFSET 0 LIMIT 10
  2.  
Jun 20 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.