11.7. Indexes on Expressions

An index column need not be just a column of the underlying table, but can be a function or scalar expression computed from one or more columns of the table. This feature is useful to obtain fast access to tables based on the results of computations. For example, a common way to do case-insensitive comparisons is to use the lower function: SELECT * FROM test1 WHERE lower(col1) = 'value'; This quer

[kamipo]

MySQLにJSON型だけきてもインデックスに関数やオペレータを使えないままではPostgreSQLとは使い勝手がまったく別物であろうという現実がある http://t.co/IEjbmFPXR7