RE: [SQL] setting select limit?

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 >-----------