Skip site navigation (1) Skip section navigation (2)

RE: [GENERAL] LIMIT QUESTION

From: "Martin Wong" <martin(at)minook(dot)com(dot)sg>
To: <pgsql-general(at)postgresql(dot)org>
Subject: RE: [GENERAL] LIMIT QUESTION
Date: 1999-04-29 14:20:27
Message-ID: 00a301be924b$6dc6cc20$6500a8c0@martin (view raw or flat)
Thread:
Lists: pgsql-general
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'
>
>
>



Responses

pgsql-general by date

Next:From: Martin WongDate: 1999-04-29 14:22:26
Subject: RE: [GENERAL] LIMIT QUESTION
Previous:From: José SoaresDate: 1999-04-29 14:07:02
Subject: Re: [GENERAL] LIMIT QUESTION

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group