Hi Sumeet Can you give us an example of the data inside that column? Then I might be able to suggest a SQL snippet to extract latitude and longitude out for attributes.
-- Pat On 29/08/2009, at 12:54 AM, sumeet panchal wrote: > > hi I am struggling with this for so long. > > I have a field named location_geom : (geometry point). It have > latitude and longitude. It stores value using georuby. > So we can have methods like lat lon x y on it. > Problem is that I want an attribute from it > > What I did is > > define_index > indexes :name > has "location_geom.lat" , :as => :latitude, :type => :float > end > > I need to index this field, if possible separately in latitude and > longitude. > please help. > > And I also get an error again and again in indexing it is: > when i do rake ts:in > > ERROR: index 'working_asset_core': incompatible schemas: attribute > count mismatch: 4 in schema 'working_asset_core_1', 5 in schema > 'working_asset_core_0'. > > what is cause and solution for this. > Please Help. > > Thanks > Sumeet > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
