Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #5293: constant function (date_trunc) is repeatedly evaluated inside loop - Mailing list pgsql-bugs

From Kevin Grittner
Subject Re: BUG #5293: constant function (date_trunc) is repeatedly evaluated inside loop
Date
Msg-id 4B56CA85020000250002E85A@gw.wicourts.gov
Whole thread Raw
In response to BUG #5293: constant function (date_trunc) is repeatedly evaluated inside loop  ("Richard Neill" <rn214@cam.ac.uk>)
Responses Re: BUG #5293: constant function (date_trunc) is repeatedly evaluated inside loop  (Richard Neill <rn214@cam.ac.uk>)
List pgsql-bugs
Tree view 
"Richard Neill" <rn214@cam.ac.uk> wrote:

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

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

-Kevin

pgsql-bugs by date:

Previous
From: Wild Wezyr
Date:
Subject: Re: BUG #5290: Simple loop with insert into and check to avoid duplicate values fails
Next
From: "Kevin Grittner"
Date:
Subject: Re: BUG #5292: Corrupted installer