No, no, no, partial index is the where clause of it and I´m not talking about that.
I´m talking about datevalue, which will be used one or another, depending on status value
This record iindex will be status and datevalue from "visitadescartada" object
{
"status": "visitadescartada",
"atribuido": {"datevalue": "2019-09-05 14:47:11"},
"visitadescartada": {"datevalue": "2019-09-12 11:47:17"},
"digitacaodescartada": {}
}
And here the index record will be status and datevalue from "atribuido" object
{
"status": "atribuido",
"atribuido": {"datevalue": "2019-09-05 14:47:11"},
"visitadescartada": {"datevalue": "2019-09-12 11:47:17"},
"digitacaodescartada": {}
}
Sent from the PostgreSQL - general mailing list archive at Nabble.com.