RE: [GENERAL] LIMIT QUESTION

dbtest=> set QUERY_LIMIT TO 10;
ERROR: parser: parse error at or near "10"
dbtest=> set QUERY_LIMT TO 10;
ERROR: parser: parse error at or near "10"

Didn't work. I guess I'll have to re-install postgresql 6.5

BTW, is this 6.5 version stable enough for production?
Please comment.

And also if 6.4.2 is up to production level. I'm sure it is though, haven't
found any problems yet.

Thanks

Martin

-----Original Message-----
·ol : José Soares <jose(at)sferacarta(dot)com>
ˆ¶æ : Chris Bitmead <chris(dot)bitmead(at)bigfoot(dot)com>
CC : Martin Wong <martin(at)minook(dot)com(dot)sg>; pgsql-general(at)postgresql(dot)org
<pgsql-general(at)postgresql(dot)org>
“úŽž : 1999”N4ŒŽ30“ú 0:01
Œ–¼ : Re: [GENERAL] LIMIT QUESTION

>Chris Bitmead ha scritto:
>
>> 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
>
>Use SET QUERY_LIMT TO 10;
>this should work in 6.4.2
>______________________________________________________________
>PostgreSQL 6.5.0 on i586-pc-linux-gnu, compiled by gcc 2.7.2.3
>^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>Jose'
>
>
>