Hi Pat,
define_index do
indexes :name, company, description, street, loc_info, zip, city,
services, tags, hidden, internal, country
has 'RADIANS(lat)', :as => :lat, :type => :float
has 'RADIANS(lng)', :as => :lng, :type => :float
# sphinx converts string attributes to integers internally, but we
don't know to what...
# to be able to filter on these values we need a (known) integer
hash function
# and since psql doesn't support CRC32, we invent one - it's
basically first 8 integer digits from md5 hash of the field
has "cast(substring(translate(md5(status), 'abcdef', '') from 1
for 8) as integer)", :as => :status_hash, :type => :integer
has "cast(substring(translate(md5(uploaded_as), 'abcdef', '') from
1 for 8) as integer)", :as => :uploaded_as_hash, :type => :integer
has :wifi
has :student_coupon
has :has_active_deal
set_property :field_weights => {'name' => 50, 'company' => 1000,
'city' => 80}
set_property :delta => true
end
Postgresql: 8.4.0
TS: 1.3.2
I ment normal associated model..
Thank you!
david
On Aug 27, 5:11 am, Pat Allan <[email protected]> wrote:
> Hi David
>
> Is there anything else in the define_index block? And which versions of
> Thinking Sphinx and PostgreSQL are you using?
>
> Also: when you say submodel, do you mean associated model? Or is there some
> inheritance as part of all of this?
>
> Cheers
>
> --
> Pat
>
> On 25/08/2011, at 7:13 PM, David Krmpotic wrote:
>
>
>
>
>
>
>
> > Hello,
>
> > I have a problem with indexing a submodel attribute.
>
> > class Spot < ...
> > has_many :deals
>
> > define_index do
> > indexes :name, company, description
> > indexes deals.title, :as => :deal
> > end
> > end
>
> > I get this: ERROR: index 'spot_core': sql_range_query: ERROR: column
> > "spots.id" must appear in the GROUP BY clause or be used in an
> > aggregate function
> > LINE 1: SELECT "spots"."id" * 2 + 1 AS "id" , "spots"."name" AS
> > "nam...
>
> > I'm using Postgres.
>
> > The error disappears when I remove indexes deals.title, :as => :deal
>
> > Can you please help?
> > Thank you!
>
> > David
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "Thinking Sphinx" group.> To post to this group, send email
> > [email protected].> To unsubscribe from this group, send
> > email [email protected].
> > For more options, visit this group
> > athttp://groups.google.com/group/thinking-sphinx?hl=en.
--
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.
