Robert DiFalco wrote:
> I just have a single VARCHAR field for name, so the full name
> "William S. Burroughs" is a single row and column. I want to as
> simply as possible have the ability to search find this record
> with Will, will, Burr, burroughs, etc.
> As far as I can tell, the trigram ex
On Tue, Nov 18, 2014 at 11:49 AM, Robert DiFalco
wrote:
> Either I'm not that smart or I am working on too many things at once (or
> both) but making Full Text work seems super tedious. I just have a single
> VARCHAR field for name, so the full name "William S. Burroughs" is a single
> row and co
On Nov 18, 2014, at 11:49 AM, Robert DiFalco wrote:
> As far as I can tell, the trigram extension would be the easiest way to
> implement this. It looks like I wouldn't need to mess with vectors, etc. It
> would just look like a standard index and query, right? It seems that if I
> need someth
Thanks everyone.
Either I'm not that smart or I am working on too many things at once (or
both) but making Full Text work seems super tedious. I just have a single
VARCHAR field for name, so the full name "William S. Burroughs" is a single
row and column. I want to as simply as possible have the a
On Nov 18, 2014, at 7:38 AM, Albe Laurenz wrote:
>
> That index wouldn't help with the query at all.
>
> If you really need a full substring search (i.e., you want to find
> "howardjohnson"), the only thing that could help are trigram indexes.
I stand corrected.
I ran a sample query on my te
On 11/17/2014 7:54 PM, Jonathan Vanasco wrote:
On Nov 17, 2014, at 12:55 PM, Robert DiFalco wrote:
SELECT * FROM MyTable WHERE upper(FullName) LIKE upper('%John%');
That said, which would be the best extension module to use? A "gist" index on
the uppercased column? Or something else? Th
Jonathan Vanasco wrote:
> On Nov 17, 2014, at 12:55 PM, Robert DiFalco wrote:
>> SELECT * FROM MyTable WHERE upper(FullName) LIKE upper('%John%');
>>
>> That said, which would be the best extension module to use? A "gist" index
>> on the uppercased column?
>> Or something else? Thanks!
>
> Pe
Jonathan Vanasco-7 wrote
> The reason is that GIN/GIST use language patterns to simplify the index.
> so they work great on "words"
>
> select plainto_tsquery('doing watching reading programming');
> 'watch' & 'read' & 'program'
>
> but not so great on "names":
>
> select plai
On Nov 17, 2014, at 12:55 PM, Robert DiFalco wrote:
> SELECT * FROM MyTable WHERE upper(FullName) LIKE upper('%John%');
>
> That said, which would be the best extension module to use? A "gist" index on
> the uppercased column? Or something else? Thanks!
Performance wise, I think a function
I notice there are several modules to create specialized indices in
PostgreSQL for searching VARCHAR data. For example, fuzzy, trigram, full
text, etc.
I've been googling around but I can't find the optimal method (reasonable
speed and size, simplicity) for my use case.
My text searches will alw
10 matches
Mail list logo
