On 06/27/2013 12:42 PM, Dave Johansen wrote:
> Or what about something like DATE_TRUNC("DAY", now())? Or would that run
> into the same optimization/planner problems as CURRENT_DATE?
Same issue. This seems to work, though I'm not entirely sure of the
implications:
UPDATE pg_proc
SET provolatile = 'i'
WHERE proname = 'date_in';
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
sthomas(at)optionshouse(dot)com
______________________________________________
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email