Add support for "citext" field type In postgresql SQLdb connection class
Original Reporter info from Mantis: DomenicoMammola @Mammola
-
Reporter name: Domenico Mammola
Original Reporter info from Mantis: DomenicoMammola @Mammola
- Reporter name: Domenico Mammola
Description:
Hi,
this is just a suggestion:
as Postgresql supports "citext" field type (https://www.postgresql.org/docs/9.1/citext.html) that is a case insesitive character string type, much similar to "text" field type and useful to allow comparison against text field in a case insensitive manner as it happens, as default behaviour, in other db engines like MySQL or Microsoft SQLServer or Oracle.
It could be really useful to support it in the postgresql sqldb connection class.
I have tryed to patch the pqconnection unit to add citext support and made some tests against Postgresql 11 and it seems to work fine.
Enclosed the patch file, I hope it could be useful.
Domenico