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-----
> ol : 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>
> : 1999N430 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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org