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@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
