Lazy View's Column Computing

Поиск
Список
Период
Сортировка
От Avi Weinberg
Тема Lazy View's Column Computing
Дата
Msg-id DB9PR07MB7180094FC2775BFD3A61CC0DCBEF9@DB9PR07MB7180.eurprd07.prod.outlook.com
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Automatic backup in windows
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Lazy View's Column Computing