Integer fields and auto-complete clients - Mailing list pgsql-general

From Tim Smith
Subject Integer fields and auto-complete clients
Date
Msg-id CA+HuS5FxRcj3D89EVEev0PT7No090QrRPtcuxoUuSNRCrXGc_Q@mail.gmail.com
Whole thread Raw
Responses Re: Integer fields and auto-complete clients  (Steve Atkins <steve@blighty.com>)
List 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


pgsql-general by date:

Previous
From: rob stone
Date:
Subject: Re: Locking question
Next
From: Steve Atkins
Date:
Subject: Re: Integer fields and auto-complete clients