RE: [GENERAL] LIMIT QUESTION

v6.5 is definitely not stable enough for production...purely a "use at own
risk" at this time...

On Thu, 29 Apr 1999, Martin Wong wrote:

> 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@sferacarta.com>
> ���� : Chris Bitmead <chris.bitmead@bigfoot.com>
> CC : Martin Wong <martin@minook.com.sg>; pgsql-general@postgresql.org
> <pgsql-general@postgresql.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'
> >
> >
> >
>
>
>

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org