From: | "Neil Burrows" <maillist(at)remo(dot)demon(dot)co(dot)uk> |
---|---|
To: | "Oleg Bartunov" <oleg(at)sai(dot)msu(dot)su> |
Cc: | <pgsql-sql(at)postgreSQL(dot)org> |
Subject: | RE: [SQL] setting select limit? |
Date: | 1999-02-11 10:20:12 |
Message-ID: | 000901be55a8$1bea7710$c6cb9284@towhee.gssec.bt.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi,
> You need v6.4.2-feature-patch which implement LIMIT option:
Or alternatively if you can't or don't want to apply a patch, have a look at
the
SET QUERY_LIMIT TO x
in Postgres 6.4
Command: set
Description: set run-time environment
Syntax:
SET DateStyle TO
'ISO'|'SQL'|'Postgres'|'European'|'US'|'NonEuropean'
set GEQO TO 'ON[=#]'|'OFF'
set R_PLANS TO 'ON'| 'OFF'
set QUERY_LIMIT TO #
function in postgres 6.4
Regards,
---[ Neil Burrows ]-----------------------------------------------------
E-mail: neil(dot)burrows(at)gssec(dot)bt(dot)co(dot)uk British Telecom Plc.
: neil(at)pawprint(dot)co(dot)uk Glasgow Engineering Centre
Web : http://www.remo.demon.co.uk/ Highburgh Rd. Glasgow UK
-----------< Any views expressed are not those of my employer >-----------
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 1999-02-11 12:13:37 | Re: [SQL] RULE questions. |
Previous Message | Neil Burrows | 1999-02-11 10:15:27 | RULE questions. |