Mongodb multiple indices per field

Question

To enable unique index in node I do:

City.native(function(err, collection) {
    collection.ensureIndex({
        'name': 1,
    }, function(err, result) {
        //nothing
    });
});

But I would like to enable text index on name also. So after doing the above I do:

City.native(function(err, collection) {
    collection.ensureIndex({
        'name': 'text'
    }, function(err, result) {
        //nothing
    });
});

This perfectly creates both indices. My question is, is there any chance to merge this code?? I tried with

City.native(function(err, collection) {
    collection.ensureIndex({
        'name': 1,
        'name': 'text'
    }, function(err, result) {
        //nothing
    });
});

but this creates just the text index.

you want to create two indexes. that requires running two create index commands. — Asya Kamsky, Sep 01 '14 at 20:02

score 1 · Answer 1 · edited Sep 01 '14 at 19:32

1

To enable unique index in node you need to do :

City.native(function(err, collection) {
    collection.ensureIndex(
        {'name': 1},
        {unique:true}, 
        function(err, result) {
        //nothing
    });
});

Now to merge this code:(If no-ordering is specified for index then it is ascending order)

City.native(function(err, collection) {
    collection.ensureIndex(
        {'name': 'text'},
        {unique:true},
        function(err, result) {
        //nothing
    });
});

edited Sep 01 '14 at 19:32

martskins

2,920
4
26
52

answered Sep 01 '14 at 19:01

vmr

1,895
13
24

Isn't that supposed to be `.ensureIndex({name:'text'},{unique:true},function(err, result){ ... nothing ...})` ? – martskins Sep 01 '14 at 19:09
yes @lascort... edited the post, I had missed the braces , thanks. – vmr Sep 01 '14 at 19:15

Mongodb multiple indices per field

1 Answers1