> Distinct returns a single bson document, it's not like SQLs distinct, if I
> remember right the function outputs three fields in that document, one
> being the results.

> On 5 October 2012 22:30, aliane abdelouahab <alabdeloua...@gmail.com> wrote:

> > hi
> > it's a bizarre thing i got:

> > db.users.find({"adresse.coord":{"$within":{"$center":[[4.365041,
> > 36.743954], 100]}}}).distinct("produit_up")
> > Out[17]:
> > [{u'avatar': {u'avctype': u'image/jpeg',
> >    u'orientation': u'portrait',
> >    u'photo': ObjectId('506f2ee93a5f3a0528ab8621')},
> >   u'spec': {u'abus': 0,
> >    u'date': u'2012-10-05',
> >    u'description': u'brrrrrrrrrrr',
> >    u'id': u'tofla134946378579',
> >    u'namep': u'nokia 6230',
> >    u'nombre': 2,
> >    u'prix': 1000,
> >    u'tags': [u'nokia', u'6230', u'photo'],
> >    u'vendu': False}},
> >  {u'avatar': {u'avctype': u'image/jpeg',
> >    u'orientation': u'portrait',
> >    u'photo': ObjectId('506867863a5f3a0ea84dcd6c')},
> >   u'spec': {u'abus': 0,
> >    u'date': u'2012-09-30',
> >    u'description': u"portable tr\xe8s solide, peu servi, avec batterie
> > d'une autonomie de 3 heures.",
> >    u'id': u'alucaard134901952647',
> >    u'namep': u'nokia 3310',
> >    u'nombre': 1,
> >    u'prix': 1000,
> >    u'tags': [u'portable', u'nokia', u'3310'],
> >    u'vendu': False}},
> >  {u'avatar': {u'avctype': u'image/jpeg',
> >    u'orientation': u'portrait',
> >    u'photo': ObjectId('506f2b3e3a5f3a0b3c4731a9')},
> >   u'spec': {u'abus': 0,
> >    u'date': u'2012-10-05',
> >    u'description': u'bzzzzzzzzzz',
> >    u'id': u'alucaard134946284638',
> >    u'namep': u'nokia 6230',
> >    u'nombre': 1,
> >    u'prix': 2000,
> >    u'tags': [u'nokia', u'nok', u'noki'],
> >    u'vendu': False}}]

> > db.users.find({"adresse.coord":{"$within":{"$center":[[4.365041,
> > 36.743954], 100]}}}).count()
> > Out[18]: 2

> > len(db.users.find({"adresse.coord":{"$within":{"$center":[[4.365041,
> > 36.743954], 100]}}}).distinct("produit_up"))
> > Out[19]: 3

> > --
> > You received this message because you are subscribed to the Google
> > Groups "mongodb-user" group.
> > To post to this group, send email to mongodb-user@googlegroups.com
> > To unsubscribe from this group, send email to
> > mongodb-user+unsubscribe@googlegroups.com
> > See also the IRC channel -- freenode.net#mongodb

> Distinct returns a single bson document, it's not like SQLs distinct, if I
> remember right the function outputs three fields in that document, one
> being the results.

> On 5 October 2012 22:30, aliane abdelouahab <alabdeloua...@gmail.com> wrote:

> > hi
> > it's a bizarre thing i got:

> > db.users.find({"adresse.coord":{"$within":{"$center":[[4.365041,
> > 36.743954], 100]}}}).distinct("produit_up")
> > Out[17]:
> > [{u'avatar': {u'avctype': u'image/jpeg',
> >    u'orientation': u'portrait',
> >    u'photo': ObjectId('506f2ee93a5f3a0528ab8621')},
> >   u'spec': {u'abus': 0,
> >    u'date': u'2012-10-05',
> >    u'description': u'brrrrrrrrrrr',
> >    u'id': u'tofla134946378579',
> >    u'namep': u'nokia 6230',
> >    u'nombre': 2,
> >    u'prix': 1000,
> >    u'tags': [u'nokia', u'6230', u'photo'],
> >    u'vendu': False}},
> >  {u'avatar': {u'avctype': u'image/jpeg',
> >    u'orientation': u'portrait',
> >    u'photo': ObjectId('506867863a5f3a0ea84dcd6c')},
> >   u'spec': {u'abus': 0,
> >    u'date': u'2012-09-30',
> >    u'description': u"portable tr\xe8s solide, peu servi, avec batterie
> > d'une autonomie de 3 heures.",
> >    u'id': u'alucaard134901952647',
> >    u'namep': u'nokia 3310',
> >    u'nombre': 1,
> >    u'prix': 1000,
> >    u'tags': [u'portable', u'nokia', u'3310'],
> >    u'vendu': False}},
> >  {u'avatar': {u'avctype': u'image/jpeg',
> >    u'orientation': u'portrait',
> >    u'photo': ObjectId('506f2b3e3a5f3a0b3c4731a9')},
> >   u'spec': {u'abus': 0,
> >    u'date': u'2012-10-05',
> >    u'description': u'bzzzzzzzzzz',
> >    u'id': u'alucaard134946284638',
> >    u'namep': u'nokia 6230',
> >    u'nombre': 1,
> >    u'prix': 2000,
> >    u'tags': [u'nokia', u'nok', u'noki'],
> >    u'vendu': False}}]

> > db.users.find({"adresse.coord":{"$within":{"$center":[[4.365041,
> > 36.743954], 100]}}}).count()
> > Out[18]: 2

> > len(db.users.find({"adresse.coord":{"$within":{"$center":[[4.365041,
> > 36.743954], 100]}}}).distinct("produit_up"))
> > Out[19]: 3

> > --
> > You received this message because you are subscribed to the Google
> > Groups "mongodb-user" group.
> > To post to this group, send email to mongodb-user@googlegroups.com
> > To unsubscribe from this group, send email to
> > mongodb-user+unsubscribe@googlegroups.com
> > See also the IRC channel -- freenode.net#mongodb

> Distinct returns a single bson document, it's not like SQLs distinct, if I remember right the function outputs three fields in that document, one being the results.

> On 5 October 2012 22:30, aliane abdelouahab <alabdeloua...@gmail.com> wrote:
> hi
> it's a bizarre thing i got:

> db.users.find({"adresse.coord":{"$within":{"$center":[[4.365041,
> 36.743954], 100]}}}).distinct("produit_up")
> Out[17]:
> [{u'avatar': {u'avctype': u'image/jpeg',
>    u'orientation': u'portrait',
>    u'photo': ObjectId('506f2ee93a5f3a0528ab8621')},
>   u'spec': {u'abus': 0,
>    u'date': u'2012-10-05',
>    u'description': u'brrrrrrrrrrr',
>    u'id': u'tofla134946378579',
>    u'namep': u'nokia 6230',
>    u'nombre': 2,
>    u'prix': 1000,
>    u'tags': [u'nokia', u'6230', u'photo'],
>    u'vendu': False}},
>  {u'avatar': {u'avctype': u'image/jpeg',
>    u'orientation': u'portrait',
>    u'photo': ObjectId('506867863a5f3a0ea84dcd6c')},
>   u'spec': {u'abus': 0,
>    u'date': u'2012-09-30',
>    u'description': u"portable tr\xe8s solide, peu servi, avec batterie
> d'une autonomie de 3 heures.",
>    u'id': u'alucaard134901952647',
>    u'namep': u'nokia 3310',
>    u'nombre': 1,
>    u'prix': 1000,
>    u'tags': [u'portable', u'nokia', u'3310'],
>    u'vendu': False}},
>  {u'avatar': {u'avctype': u'image/jpeg',
>    u'orientation': u'portrait',
>    u'photo': ObjectId('506f2b3e3a5f3a0b3c4731a9')},
>   u'spec': {u'abus': 0,
>    u'date': u'2012-10-05',
>    u'description': u'bzzzzzzzzzz',
>    u'id': u'alucaard134946284638',
>    u'namep': u'nokia 6230',
>    u'nombre': 1,
>    u'prix': 2000,
>    u'tags': [u'nokia', u'nok', u'noki'],
>    u'vendu': False}}]

> db.users.find({"adresse.coord":{"$within":{"$center":[[4.365041,
> 36.743954], 100]}}}).count()
> Out[18]: 2

> len(db.users.find({"adresse.coord":{"$within":{"$center":[[4.365041,
> 36.743954], 100]}}}).distinct("produit_up"))
> Out[19]: 3

> --
> You received this message because you are subscribed to the Google
> Groups "mongodb-user" group.
> To post to this group, send email to mongodb-user@googlegroups.com
> To unsubscribe from this group, send email to
> mongodb-user+unsubscribe@googlegroups.com
> See also the IRC channel -- freenode.net#mongodb

> --
> You received this message because you are subscribed to the Google
> Groups "mongodb-user" group.
> To post to this group, send email to mongodb-user@googlegroups.com
> To unsubscribe from this group, send email to
> mongodb-user+unsubscribe@googlegroups.com
> See also the IRC channel -- freenode.net#mongodb

> Distinct returns unique values for the specified field

> You may (if I recall correctly) be getting duplicated entires if you have more than one addresse field per document, as it may match twice.

> Russ
> Rainforest  |  +1-650-919-3216 |  rainforestqa.com

> On Oct 5, 2012, at 2:36 PM, Sam Millman <sam.mill...@gmail.com> wrote:

> > Distinct returns a single bson document, it's not like SQLs distinct, if I remember right the function outputs three fields in that document, one being the results.

> > On 5 October 2012 22:30, aliane abdelouahab <alabdeloua...@gmail.com> wrote:
> > hi
> > it's a bizarre thing i got:

> > db.users.find({"adresse.coord":{"$within":{"$center":[[4.365041,
> > 36.743954], 100]}}}).distinct("produit_up")
> > Out[17]:
> > [{u'avatar': {u'avctype': u'image/jpeg',
> >    u'orientation': u'portrait',
> >    u'photo': ObjectId('506f2ee93a5f3a0528ab8621')},
> >   u'spec': {u'abus': 0,
> >    u'date': u'2012-10-05',
> >    u'description': u'brrrrrrrrrrr',
> >    u'id': u'tofla134946378579',
> >    u'namep': u'nokia 6230',
> >    u'nombre': 2,
> >    u'prix': 1000,
> >    u'tags': [u'nokia', u'6230', u'photo'],
> >    u'vendu': False}},
> >  {u'avatar': {u'avctype': u'image/jpeg',
> >    u'orientation': u'portrait',
> >    u'photo': ObjectId('506867863a5f3a0ea84dcd6c')},
> >   u'spec': {u'abus': 0,
> >    u'date': u'2012-09-30',
> >    u'description': u"portable tr\xe8s solide, peu servi, avec batterie
> > d'une autonomie de 3 heures.",
> >    u'id': u'alucaard134901952647',
> >    u'namep': u'nokia 3310',
> >    u'nombre': 1,
> >    u'prix': 1000,
> >    u'tags': [u'portable', u'nokia', u'3310'],
> >    u'vendu': False}},
> >  {u'avatar': {u'avctype': u'image/jpeg',
> >    u'orientation': u'portrait',
> >    u'photo': ObjectId('506f2b3e3a5f3a0b3c4731a9')},
> >   u'spec': {u'abus': 0,
> >    u'date': u'2012-10-05',
> >    u'description': u'bzzzzzzzzzz',
> >    u'id': u'alucaard134946284638',
> >    u'namep': u'nokia 6230',
> >    u'nombre': 1,
> >    u'prix': 2000,
> >    u'tags': [u'nokia', u'nok', u'noki'],
> >    u'vendu': False}}]

> > db.users.find({"adresse.coord":{"$within":{"$center":[[4.365041,
> > 36.743954], 100]}}}).count()
> > Out[18]: 2

> > len(db.users.find({"adresse.coord":{"$within":{"$center":[[4.365041,
> > 36.743954], 100]}}}).distinct("produit_up"))
> > Out[19]: 3

> > --
> > You received this message because you are subscribed to the Google
> > Groups "mongodb-user" group.
> > To post to this group, send email to mongodb-user@googlegroups.com
> > To unsubscribe from this group, send email to
> > mongodb-user+unsubscribe@googlegroups.com
> > See also the IRC channel -- freenode.net#mongodb

> > --
> > You received this message because you are subscribed to the Google
> > Groups "mongodb-user" group.
> > To post to this group, send email to mongodb-user@googlegroups.com
> > To unsubscribe from this group, send email to
> > mongodb-user+unsubscribe@googlegroups.com
> > See also the IRC channel -- freenode.net#mongodb

> Unless distinct works differently on the find of geospatial query then no
> since the distinct would have have only two documents to distinct then.

> On 6 October 2012 22:52, aliane abdelouahab <alabdeloua...@gmail.com> wrote:

> > here it's the coordinates, and because there is a duplicated value
> > that it has been omited to return 2 instead of 3?

> > On 6 oct, 17:25, Russell Smith <r...@rainforestapp.com> wrote:
> > > Distinct returns unique values for the specified field

> > > You may (if I recall correctly) be getting duplicated entires if you
> > have more than one addresse field per document, as it may match twice.

> > > Russ
> > > Rainforest  |  +1-650-919-3216 |  rainforestqa.com

> > > On Oct 5, 2012, at 2:36 PM, Sam Millman <sam.mill...@gmail.com> wrote:

> > > > Distinct returns a single bson document, it's not like SQLs distinct,
> > if I remember right the function outputs three fields in that document, one
> > being the results.

> > > > On 5 October 2012 22:30, aliane abdelouahab <alabdeloua...@gmail.com>
> > wrote:
> > > > hi
> > > > it's a bizarre thing i got:

> > > > db.users.find({"adresse.coord":{"$within":{"$center":[[4.365041,
> > > > 36.743954], 100]}}}).distinct("produit_up")
> > > > Out[17]:
> > > > [{u'avatar': {u'avctype': u'image/jpeg',
> > > >    u'orientation': u'portrait',
> > > >    u'photo': ObjectId('506f2ee93a5f3a0528ab8621')},
> > > >   u'spec': {u'abus': 0,
> > > >    u'date': u'2012-10-05',
> > > >    u'description': u'brrrrrrrrrrr',
> > > >    u'id': u'tofla134946378579',
> > > >    u'namep': u'nokia 6230',
> > > >    u'nombre': 2,
> > > >    u'prix': 1000,
> > > >    u'tags': [u'nokia', u'6230', u'photo'],
> > > >    u'vendu': False}},
> > > >  {u'avatar': {u'avctype': u'image/jpeg',
> > > >    u'orientation': u'portrait',
> > > >    u'photo': ObjectId('506867863a5f3a0ea84dcd6c')},
> > > >   u'spec': {u'abus': 0,
> > > >    u'date': u'2012-09-30',
> > > >    u'description': u"portable tr\xe8s solide, peu servi, avec batterie
> > > > d'une autonomie de 3 heures.",
> > > >    u'id': u'alucaard134901952647',
> > > >    u'namep': u'nokia 3310',
> > > >    u'nombre': 1,
> > > >    u'prix': 1000,
> > > >    u'tags': [u'portable', u'nokia', u'3310'],
> > > >    u'vendu': False}},
> > > >  {u'avatar': {u'avctype': u'image/jpeg',
> > > >    u'orientation': u'portrait',
> > > >    u'photo': ObjectId('506f2b3e3a5f3a0b3c4731a9')},
> > > >   u'spec': {u'abus': 0,
> > > >    u'date': u'2012-10-05',
> > > >    u'description': u'bzzzzzzzzzz',
> > > >    u'id': u'alucaard134946284638',
> > > >    u'namep': u'nokia 6230',
> > > >    u'nombre': 1,
> > > >    u'prix': 2000,
> > > >    u'tags': [u'nokia', u'nok', u'noki'],
> > > >    u'vendu': False}}]

> > > > db.users.find({"adresse.coord":{"$within":{"$center":[[4.365041,
> > > > 36.743954], 100]}}}).count()
> > > > Out[18]: 2

> > > > len(db.users.find({"adresse.coord":{"$within":{"$center":[[4.365041,
> > > > 36.743954], 100]}}}).distinct("produit_up"))
> > > > Out[19]: 3

> > > > --
> > > > You received this message because you are subscribed to the Google
> > > > Groups "mongodb-user" group.
> > > > To post to this group, send email to mongodb-user@googlegroups.com
> > > > To unsubscribe from this group, send email to
> > > > mongodb-user+unsubscribe@googlegroups.com
> > > > See also the IRC channel -- freenode.net#mongodb

> > > > --
> > > > You received this message because you are subscribed to the Google
> > > > Groups "mongodb-user" group.
> > > > To post to this group, send email to mongodb-user@googlegroups.com
> > > > To unsubscribe from this group, send email to
> > > > mongodb-user+unsubscribe@googlegroups.com
> > > > See also the IRC channel -- freenode.net#mongodb

> > --
> > You received this message because you are subscribed to the Google
> > Groups "mongodb-user" group.
> > To post to this group, send email to mongodb-user@googlegroups.com
> > To unsubscribe from this group, send email to
> > mongodb-user+unsubscribe@googlegroups.com
> > See also the IRC channel -- freenode.net#mongodb