The behavior i'm expecting is something similar to a GROUP BY in a
relational database.

SELECT product_name, model, min(price), max(price), count(*) FROM t
GROUP BY product_name, model

The current schema:

product_name (type: text)
model (type: text)
price (type: sfloat)


On Fri, Aug 7, 2009 at 11:07 AM, Yao Ge<yao...@gmail.com> wrote:
>
> Are your product_name* fields numeric fields (integer or float)?
>
>
> Dals wrote:
>>
>> Hi...
>>
>> Is there any way to group values like shopping.yahoo.com or
>> shopper.cnet.com do?
>>
>> For instance, I have documents like:
>>
>> doc1 - product_name1 - value1
>> doc2 - product_name1 - value2
>> doc3 - product_name1 - value3
>> doc4 - product_name2 - value4
>> doc5 - product_name2 - value5
>> doc6 - product_name2 - value6
>>
>> I'd like to have a result grouping by product name with the value
>> range per product. Something like:
>>
>> product_name1 - (value1 to value3)
>> product_name2 - (value4 to value6)
>>
>> It is not like the current facet because the information is grouped by
>> item, not the entire result.
>>
>> Any idea?
>>
>> Thanks!
>>
>> David Lojudice Sobrinho
>>
>>
>
> --
> View this message in context: 
> http://www.nabble.com/Item-Facet-tp24853669p24865535.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>
>



-- 
__________________

   David L. S.
dalss...@gmail.com
__________________

Reply via email to