Re: Variable LIMIT and OFFSET in SELECTs - Mailing list pgsql-general

From Reg Me Please
Subject Re: Variable LIMIT and OFFSET in SELECTs
Date
Msg-id 200711151948.18678.regmeplease@gmail.com
Whole thread Raw
In response to Re: Variable LIMIT and OFFSET in SELECTs  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Variable LIMIT and OFFSET in SELECTs  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Sorry but I don't understand.

Either the LIMIT and OFFSET are to be definitely CONSTANT or not.

In the SQL function body the LIMIT and the OFFSET *are definitely not*
CONSTANT. And the planner can do its job at best as usual.

As Sam says I should be able to "put an IMMUTABLE expression into a LIMIT or
OFFSET". And under some circumstances (SQL function body) it's true even with
VARIABLE expressions like function call arguments.

In my opinion I would say it's more a problem with the syntax checker that
with the planner ("semantics" in my lingo). But I could be wrong.

--
Reg me Please

pgsql-general by date:

Previous
From: Ray Stell
Date:
Subject: Cisco MDS support
Next
From: Richard Huxton
Date:
Subject: Re: Variable LIMIT and OFFSET in SELECTs