Re: [HACKERS] Alternative to LIMIT in SELECT ? - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: [HACKERS] Alternative to LIMIT in SELECT ?
Date
Msg-id 199810140140.KAA14328@srapc451.sra.co.jp
Whole thread Raw
In response to [HACKERS] Alternative to LIMIT in SELECT ?  (Marc Howard Zuckman <marc@fallon.classyad.com>)
List pgsql-hackers
This might be off-topic, but...

I've found ExecutorLimit() (in executor/execMain.c) is useful for me
especially when issuing an ad-hock query via psql. I personally use
the function with customized set command.

set query_limit to 'num';

    limit the max number of results returned by the backend

show query_limit;

    display the current query limit

reset query_limit;

    disable the query limit (unlimited number of results allowed)
--
Tatsuo Ishii
t-ishii@sra.co.jp

pgsql-hackers by date:

Previous
From: "Thomas G. Lockhart"
Date:
Subject: Re: [HACKERS] PostgreSQL v6.4 BETA2 ...
Next
From: "Thomas G. Lockhart"
Date:
Subject: Re: [HACKERS] Alternative to LIMIT in SELECT ?