LIMIT QUESTION - Mailing list pgsql-general

From Martin Wong
Subject LIMIT QUESTION
Date
Msg-id 00a601be91e5$039fdfa0$6500a8c0@martin
Whole thread Raw
List pgsql-general
Hi,

I've an elementary question. What's wrong with the following :

dbtest=> select * from testusers limit 10;
ERROR:  parser: parse error at or near "10"
dbtest=> select version();
version
-------------------------------------------------------------
PostgreSQL 6.4.2 on i586-pc-linux-gnu, compiled by gcc 2.7.2.
(1 row)

the testuser table has about 1000 rows.

Please comment.

Thanks



pgsql-general by date:

Previous
From: Andy Lewis
Date:
Subject: Re: [GENERAL] PLpgSQL Stat Problem
Next
From: Michael J Davis
Date:
Subject: RE: [GENERAL] LIMIT QUESTION