Re: Does postgresql 9.0.4 use index on PREFIX%SUFFIX queries?

From: Gregg Jaskiewicz <gryzman(at)gmail(dot)com>
To: Edson Carlos Ericksson Richter <richter(at)simkorp(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Does postgresql 9.0.4 use index on PREFIX%SUFFIX queries?
Date: 2011-09-26 13:01:12
Message-ID: CAJY59_jcqWObA_1aD2OZVA4J_XDsKD5NRzhOEZiK408m8LvTTA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

You can always store it divided in the database into two columns.
Gist could also work for you.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2011-09-26 13:32:20 Re: changing from postgreSQL 8.3 to 9.0
Previous Message Adam Tistler 2011-09-26 12:54:43 timeline X of the primary does not match recovery target timeline Y