| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | depesz(at)depesz(dot)com |
| Cc: | pgsql-general(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: Why extract( ... from timestamp ) is not immutable? |
| Date: | 2012-01-25 16:10:19 |
| Message-ID: | 201201250810.20394.adrian.klaver@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2012-01-25 16:11:06 | Re: Index on parent/child hierarchy |
| Previous Message | hubert depesz lubaczewski | 2012-01-25 16:08:37 | Re: Why extract( ... from timestamp ) is not immutable? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hubert depesz lubaczewski | 2012-01-25 16:13:11 | Re: Why extract( ... from timestamp ) is not immutable? |
| Previous Message | hubert depesz lubaczewski | 2012-01-25 16:08:37 | Re: Why extract( ... from timestamp ) is not immutable? |