Bonjour,

Il m'est impossible de créer un index btree sur un champ de type "varchar" car apparemment certains contient trop de données.
Les données sont des codes postaux séparés par des virgules ex :

Code : Sélectionner tout - Visualiser dans une fenêtre à part
4501,4502,4503,4505,4506,4507,4508,4509,4510,4511,4512,4513,4514,4515,4516,4517,4518,4519,4520,4521,4522,4523,4524,4525,4526,4527,4528,4529,4530,4531,4532,4533,4534,4535,4536,4537,4538,4539,4540,4541,4545,4550,4551,4552,4553,4554,4555,4556,4557,4558,4559,4560,4561,4562,4569,4570,4571,4572,4573,4574,4575,4576,4577,4578,4579,4580,4581,4582,4583,4590,4591,4592,4593,4594,4595,4596,4597,4598,4599,4601,4602,4603,4604,4605,4606,4607,4608,4609,4610,4611,4612,4620,4621,4622,4623,4624,4625,4626,4627,4628,4629,4630,4631,4632,4633,4634,4635,4636,4640,4641,4642,4643,4644,4645,4646,4647,4648,4649,4650,4651,4656,4657,4658,4659,4660,4661,4662,4663,4664,4665,4666,4667,4668,4669,4670,4671,4672,4676,4677,4678,4679,4680,4681,4682,4683,4684,4685,4686,4687,4688,4689,4690,4691,4692,4693
Comment puis-je faire ?

Merci