Is there a way to create indexes based on expressions instead of simple
columns (see:
http://www.postgresql.org/docs/8.1/static/indexes-expressional.html)? The
idea is to have some custom functions that extract data from a JSON column
and allow a fast query based on an index. This is the strategy used by
POSTGRES and DB2, for example.
I know that we can create a table and do a manual field extraction, but
this is not transparent from a query standpoint, and forces a manual re
computation of all rows when a new index is desired.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
