longclaps

Сменить Mongo на Postgres не проблема.

db.test.findOne({$or: 
  [
    {'count.day.s': {$gt: 0}},
    {'count.day.g': {$gt: 0}}
  ]
})

db.test.drop();
db.test.insert([
    {_id: 1, "area": 1, "brea": 2},
    {_id: 2, "area": 3, "brea": 4}]);
db.test.aggregate([
    {$project: {"a": ["$area", "$brea"]}},
    {$unwind: "$a"},
    {$group: {_id: "$_id", "a": {$sum: "$a"}}},
    {$match: {"a": {$gt: 5, $lt: 10}}}
]);

var a = 12;
db.talks.aggregate([
	{$project:{"_id":1,"from":1, "to":1, "msg":1, "ft":["$from", "$to"]}},
	{$match:{"ft":a}},
	{$unwind: "$ft"},	
	{$match:{"ft":{$ne:a}}},
	{$sort:{"_id":1}},
	{$group: {"_id":"$ft", "orig_id":{$last:"$_id"},"from":{$last:"$from"},
		      "to":{$last:"$to"},"msg":{$last:"$msg"}}},
	{$sort:{"_id":1}},
	{$project:{"_id":"$orig_id","from":1, "to":1, "msg":1}}
]);

db.todolists.findOneAndUpdate(
    {"needs.task": "Varshava"},
    {$set: {"needs.$.isCompleted": false}}
);

mongoexport --db video --collection movies --type=csv --fields title,year,imdb -o movies.csv