avoid select expens_expr(col) like unneccessary calculations

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: avoid select expens_expr(col) like unneccessary calculations
Date: 2003-07-07 22:35:07
Message-ID: 1057617306.2617.6.camel@saphir
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

--
Markus Bertheau.
Berlin, Berlin.
Germany.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2003-07-07 22:47:06 Re: avoid select expens_expr(col) like unneccessary calculations
Previous Message scott.marlowe 2003-07-07 19:51:29 Re: sort for ranking