Hi, This is data normally in my column (0101000020AD1000000000000000C041406666666666D65CC0) its a geometry point. and when I did this : select st_astext(location_geom) from <table> where id=1; It gives: POINT(35.5 -115.35). this is type for column: location_geom :geometry point, 4269 biggest problem I am facing the error: ERROR: index 'working_asset_core': incompatible schemas: attribute count mismatch: 4 in schema 'working_asset_core_1', 5 in schema 'working_asset_core_0'. Whenever I try to add the attribute to define_index it gives me this error.
thanks On Aug 29, 3:32 am, Pat Allan <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
