Lazy View's Column Computing - Mailing list pgsql-general

From Avi Weinberg
Subject Lazy View's Column Computing
Date
Msg-id DB9PR07MB7180094FC2775BFD3A61CC0DCBEF9@DB9PR07MB7180.eurprd07.prod.outlook.com
Whole thread Raw
Responses Re: Lazy View's Column Computing  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Lazy View's Column Computing  (Mladen Gogala <gogala.mladen@gmail.com>)
List pgsql-general

Hi,

 

Is there a way to compute a column in a view only if it is referenced in the query?  I have a view's column that its value is computed by a function.  If in the query that column is not used at all, can Postgres "skip" computing it? 

 

Thanks!  

IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Automatic backup in windows
Next
From: Tom Lane
Date:
Subject: Re: Lazy View's Column Computing