The search suggest behaves correctly.
The results returned are something else.
If I search by alpha, it seems to behave correctly
If I search by code (111) I get all kinds of out of sequence code results as show in included results below
Here is the normal search suggest you would expect from the table data below.
======================================================
======================================================
The postgresql database table:
CREATE TABLE rfxsite.naics (
naics_id BIGINT DEFAULT nextval('rfxsite.naics_naics_key_seq'::regclass) NOT NULL,
naics_desc TEXT,
naics_code TEXT,
firms_id BIGINT,
CONSTRAINT naics_pkey PRIMARY KEY(naics_id)
)
WITH (oids = false);
ALTER TABLE rfxsite.naics
OWNER TO postgres;
======================================================
======================================================
Here is the first few records of data the search is running on (I'm not doing anything - just pain results )
NAICS Code NAICS Description
111110 Soybean Farming
111120 Oilseed (except Soybean) Farming
111130 Dry Pea and Bean Farming
111140 Wheat Farming
111150 Corn Farming
111160 Rice Farming
111191 Oilseed and Grain Combination Farming
111199 All Other Grain Farming
111211 Potato Farming
111219 Other Vegetable (except Potato) and Melo More ...
111310 Orange Groves
111320 Citrus (except Orange) Groves
111331 Apple Orchards
111332 Grape Vineyards
.
.
.
======================================================
======================================================
I enter 111 in the search and get this:
Results:
NAICS Code NAICS Description
237120 Oil and Gas Pipeline and Related Structu More ...
811219 Other Electronic and Precision Equipment More ...
811310 Commercial and Industrial Machinery and More ...
811411 Home and Garden Equipment Repair and Mai More ...
811412 Appliance Repair and Maintenance
811420 Reupholstery and Furniture Repair
811430 Footwear and Leather Goods Repair
811490 Other Personal and Household Goods Repai More ...
812111 Barber Shops
812112 Beauty Salons
812113