Integer fields and auto-complete clients

From: Tim Smith <randomdev4+postgres(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Integer fields and auto-complete clients
Date: 2016-10-26 13:59:03
Message-ID: CA+HuS5FxRcj3D89EVEev0PT7No090QrRPtcuxoUuSNRCrXGc_Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm curious as to what the current advice would be in relation to
auto-complete type applications (e.g. "AJAX" type java-script "guess
as you type" applicatoins).

In relation to text fields, I know the general suggestion is gin_trgm_ops.

Is there much point even thinking about using gin_trgm_ops on integers
? I'm thinking perhaps the 'prefix' extension is better suited ? Or
is there something else altogether I should be considering to support
such applications ?

Thanks !

Tim

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Atkins 2016-10-26 14:09:07 Re: Integer fields and auto-complete clients
Previous Message jaroet 2016-10-26 13:06:02 slow performance of array_agg after upgrade from 9.2 to 9.5