How to set the query limit pre-query?

#1

I may be backing up against a tree here, but I was wondering if there
is a way to set the maximum number of results one gets from a query
before running the query. Maybe something like:

SET QUERY_LIMIT 10
SELECT * FROM Authors;

instead of

SELECT * FROM Authors
LIMIT 10;

Thanks...

ebade2000

#2

ebade2000 (AT) gmail (DOT) com wrote:

Quote:

I may be backing up against a tree here,

I like that. Sounds painful :^) You probably meant "barking".
No, this newsgroup is the right tree.

Quote:

but I was wondering if there
is a way to set the maximum number of results one gets from a query
before running the query. Maybe something like:

SET QUERY_LIMIT 10
SELECT * FROM Authors;

instead of

SELECT * FROM Authors
LIMIT 10;

There is no such setting, sorry.

Yours,
Laurenz Albe

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to set the query limit pre-query?

comp.databases.postgresql comp.databases.postgresql

How to set the query limit pre-query? - 07-13-2007 , 09:23 AM

Re: How to set the query limit pre-query? - 07-24-2007 , 07:35 AM