Re: Inconsistent values for 'now'
От | Glen Eustace |
---|---|
Тема | Re: Inconsistent values for 'now' |
Дата | |
Msg-id | 1112332070.5577.46.camel@agree-6 обсуждение исходный текст |
Ответ на | Re: Inconsistent values for 'now' (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-general |
> Offhand I'd expect the 'now' to be reduced to a timestamp constant > at the time the view is created. Hmmm, my assumption had been that the 'now' constant would be evaluated everytime the underlying SELECT was build by the planner. > although personally I'd not feel very comfortable with the idea of a > view whose contents change over time even when you weren't actually > doing anything to the database. Maybe you should rethink this idea > altogether... This technique was one that was recommended to me by an experienced DBA. Apparently, he and others use it a lot. Using the function now() rather than the literal 'now' works as expected. Thanks. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Glen and Rosanne Eustace, GodZone Internet Services, a division of AGRE Enterprises Ltd., P.O. Box 8020, Palmerston North, New Zealand 5301 Ph/Fax: +64 6 357 8168, Mob: +64 27 5 424 015, Web: www.godzone.net.nz "A Ministry specialising in providing low-cost professional Internet Services to NZ Christian Churches, Ministries and Organisations"
В списке pgsql-general по дате отправления: