Hi. I've got a text field in a table that holds this style of timestamp:
--
![]()
2014-10-23T00:00:00
I'd like to be able to create an index on the date portion of this field (as a date), because I have lots of queries that are searching for particular dates or ranges.
I've tried various ways of getting to a date (::date, LEFT(x,10)::date, etc.), but all of them throw the error "functions in index _expression_ must be marked IMMUTABLE."
Is there any way, hacky or otherwise, people know of to do this? Thanks in advance.
Ken
AGENCY Software
A Free Software data system
By and for non-profits
(253) 245-3801
learn more about AGENCY or
follow the discussion.
