Re: add more frame types in window functions (ROWS) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: add more frame types in window functions (ROWS)
Date
Msg-id 18306.1258231430@sss.pgh.pa.us
Whole thread Raw
In response to Re: add more frame types in window functions (ROWS)  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Responses Re: add more frame types in window functions (ROWS)
List pgsql-hackers
Andrew Gierth <andrew@tao11.riddles.org.uk> writes:
> (A question here: the spec allows (by my reading) the use of
> parameters in the window frame clause, i.e. BETWEEN $1 PRECEDING AND
> $2 FOLLOWING.  Wouldn't it therefore make more sense to treat the
> values as Exprs, albeit very limited ones, and eval them at startup
> rather than assuming we know the node type and digging down into it
> all over the place?)

Seems like you might as well allow any expression not containing
local Vars.  Compare the handling of LIMIT.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: add more frame types in window functions (ROWS)
Next
From: Robert Haas
Date:
Subject: Re: patch - per-tablespace random_page_cost/seq_page_cost