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 <[EMAIL PROTECTED]>
> ˆ¶æ : Chris Bitmead <[EMAIL PROTECTED]>
> CC : Martin Wong <[EMAIL PROTECTED]>; [EMAIL PROTECTED]
> <[EMAIL PROTECTED]>
> “úŽž : 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: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org
