avoid select expens_expr(col) like unneccessary calculations - Mailing list pgsql-sql

From Markus Bertheau
Subject avoid select expens_expr(col) like unneccessary calculations
Date
Msg-id 1057617306.2617.6.camel@saphir
Whole thread Raw
Responses Re: avoid select expens_expr(col) like unneccessary calculations  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: avoid select expens_expr(col) like unneccessary calculations  ("scott.marlowe" <scott.marlowe@ihs.com>)
List 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.


pgsql-sql by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: sort for ranking
Next
From: Stephan Szabo
Date:
Subject: Re: avoid select expens_expr(col) like unneccessary calculations