I'm building a web application that stores dates (amongst other
things).
I'd like to be able to search those dates in the format that they're
displayed
to the user, namely 'MM/YY'. I tried the following:
define_index do
...
indexes "date_format( filing_date, '%m/%y' )", :as => :filing_date
indexes "date_format( grant_date, '%m/%y' )", :as => :grant_date
...
end
but get the response:
ERROR: index 'record_core': sql_range_query: Column 'filing_date' in
field list is ambiguous
Any suggestions?
Guy
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/thinking-sphinx?hl=en
-~----------~----~----~----~------~----~------~--~---
