Why don't you use some type of hash like md5 for indexing ? 2010/11/30 Rob Sargent <robjsarg...@gmail.com>: > Were we to create a table which included a text field for a small block > of xml (100-1000 chars worth), would an index on that field be useful > against exact match queries? > > We're wondering if a criterion such as "where 'a string expected to be > of size range 100 to 500' = tabelWithStrings.stringSearched" would make > good use of an index on "stringSearched" column. > > The key is that there will only be exact match queries. > > Thanks for your thoughts. > > > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql >
-- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
