Re: [HACKERS] Alternative to LIMIT in SELECT ?

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: Marc Howard Zuckman <marc(at)fallon(dot)classyad(dot)com>
Cc: Eric Lee Green <eric(at)linux-hw(dot)com>, "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>, Jeff Hoffmann <jeff(at)remapcorp(dot)com>, PostgreSQL-development <hackers(at)postgreSQL(dot)org>
Subject: Re: [HACKERS] Alternative to LIMIT in SELECT ?
Date: 1998-10-14 01:40:41
Message-ID: 199810140140.KAA14328@srapc451.sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sra(dot)co(dot)jp

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas G. Lockhart 1998-10-14 02:11:06 Re: [HACKERS] Alternative to LIMIT in SELECT ?
Previous Message Thomas G. Lockhart 1998-10-14 01:33:45 Re: [HACKERS] PostgreSQL v6.4 BETA2 ...