Awesome q2a theme

Sphinx and related tables

0 like 0 dislike
There are 2 signs: the company (company) and address (adress).
Are connected by relation one to many. — ie one company can have multiple addresses.

Each location has coordinates: x, y (stored as float).

Want to find companies, addresses, which are in a certain rectangular area (that is, it is necessary that x and y were within the specified range).

Also required certain restrictions on the company (took them down), so is used to index the plate with the companies, not addresses.

That's exactly what will not work:
— sql_attr_multi will not help — it can only work with the types uint, timestamp
— sql_joined_field only works with text.

It remains only to cut off x,y 3-4 characters and translate them to integer, and then use sql_attr_multi but really don't want to do.

However, is there any alternative way? Sphinx is familiar with 1 day only, so all of its features don't know.
by | 43 views

1 Answer

0 like 0 dislike

Related questions

0 like 0 dislike
3 answers
asked Apr 11, 2019 by kovalenko_jul_s
0 like 0 dislike
2 answers
0 like 0 dislike
2 answers
asked Mar 20, 2019 by ha2bj
0 like 0 dislike
3 answers
asked Mar 25, 2019 by ruskar
110,608 questions
257,187 answers
40,796 users