Re: BUG #5293: constant function (date_trunc) is repeatedly evaluated inside loop

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Richard Neill" <rn214(at)cam(dot)ac(dot)uk>,<pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #5293: constant function (date_trunc) is repeatedly evaluated inside loop
Date: 2010-01-20 15:19:01
Message-ID: 4B56CA85020000250002E85A@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Richard Neill" <rn214(at)cam(dot)ac(dot)uk> wrote:

> date_trunc('day', timestamp '2010-01-20 10:16:55')

What happens with a "timestamp with time zone" literal?

-Kevin

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kevin Grittner 2010-01-20 15:21:46 Re: BUG #5292: Corrupted installer
Previous Message Richard Neill 2010-01-20 14:23:33 BUG #5293: constant function (date_trunc) is repeatedly evaluated inside loop