On 2012-01-25, Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote: > 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') that one gets you the wrong result. -- ⚂⚃ 100% natural -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
