Partial Indexes
A partial index is an index built over a subset of a table; the subset is defined by a conditional expression (called the predicate of the partial index). The index contains entries for only those table rows that satisfy the predicate.
CREATE INDEX access_log_client_ip_ix ON access_log (client_ip)
WHERE NOT (client_ip > inet '192.168.100.0' AND client_ip < inet '192.168.100.255');
With all that scope for reasonable disagreement, is there anything we can all agree on? How much of the hierarchy in the medal table is indisputable, and how much depends on your point of view? So we want to say that one country has done strictly better than another if the medal score of the latter can be transformed into the former by a sequence of medal additions and medal upgrades. A bit of thought shows that this is exactly equivalent to defining a partial order on triples of medals, in which a triple (G,S,B) is considered at least as good as another triple (g,s,b) if and only if it satisfies the three conditions * G ≥ g * G + S ≥ g + s * G + S + B ≥ g + s + b
C. Martınez. Proc. 6th ACMSIAM Workshop on Algorithm Engineering and Experiments and 1st ACM-SIAM Workshop on Analytic Algorithmics and Combinatorics, стр. 224--228. (2004)
A. Alroomi, F. Albasri, и J. H.Talaq. International Journal on Soft Computing, Artificial Intelligence and Applications (IJSCAI), 2 (6):
20(декабря 2013)
K. Schewe, и J. Turull Torres. Proceedings of the 2006 Conference on Information Modelling and Knowledge Bases XVII, стр. 237--244. Amsterdam, The Netherlands, The Netherlands, IOS Press, (2006)
L. Schröder, и T. Mossakowski. Algebraic Methodology And Software Technology (AMAST 2002), том 2422 из Lecture Notes in Computer Science, стр. 99--116. Springer; Berlin; http://www.springer.de, (2002)
\. Tanter, J. Noyé, D. Caromel, и P. Cointe. Proceedings of the 18th Annual ACM SIGPLAN Conference on Object-oriented Programing, Systems, Languages, and Applications, стр. 27--46. ACM, (октября 2003)
E. Candes, M. Rudelson, T. Tao, и R. Vershynin. Foundations of Computer Science, 2005. FOCS 2005. 46th Annual IEEE Symposium on, стр. 668--681. IEEE, (2005)
P. Cellier, S. Ferré, M. Ducassé, и T. Charnois. Proceedings of the 19th International Conference on Conceptual Structures (ICCS 2011), том 6828 из Lecture Notes in Computer Science, стр. 77-90. Springer, (2011)
M. Fukumi, S. Omatu, и Y. Nishikawa. Proceedings of the IEEE International joint Conference on Neural
Networks 1995, IJCNN'95, 4, стр. 1834--1838. IEEE Computer Society, (ноября 1995)