Re: Why extract( ... from timestamp ) is not immutable?

On Wednesday, January 25, 2012 7:48:34 am hubert depesz lubaczewski wrote:
> On Wed, Jan 25, 2012 at 07:44:14AM -0800, Adrian Klaver wrote:
> > > I thought that this is what I will achieve with extract(epoch from
> > > now() at time zone 'UTC') but clearly it doesn't work.
> > > So what options do I have?
> >
> > Isn't extract(epoch from now()) getting what you want?
>
> you can't make index on it.

I am afraid I am not following. So you can make an index on?:

extract(epoch from now() at time zone 'UTC')

>
> Best regards,
>
> depesz

--
Adrian Klaver
adrian.klaver@gmail.com