Re: avoid select expens_expr(col) like unneccessary calculations

On 8 Jul 2003, Markus Bertheau wrote:

> Hi,
> 
> when you have
> select expensive_expression(column), * from table offset 20 limit 40
> 
> can you somehow save the cost for the first 20 calculations of
> expensive_expression?

Might a functional or partial index work here?