Re: [GENERAL] LIMIT QUESTION - Mailing list pgsql-general

From Chris Bitmead
Subject Re: [GENERAL] LIMIT QUESTION
Date
Msg-id 3727DFFA.E0F3CF9@bigfoot.com
Whole thread Raw
In response to LIMIT QUESTION  ("Martin Wong" <martin@minook.com.sg>)
List pgsql-general
Only PostgreSQL 6.5 Beta supports LIMIT.

> 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: Michael J Davis
Date:
Subject: RE: [GENERAL] LIMIT QUESTION
Next
From: Herouth Maoz
Date:
Subject: Re: [GENERAL] Desperately Seeking Regular Expression