Received: from roanoak.netregistry.net (mail.netregistry.net [203.202.16.100]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7E60oP52276 for ; Tue, 14 Aug 2001 02:00:51 -0400 (EDT) (envelope-from scott.gilbert@netregistry.au.com) Received: from [10.1.1.138] (helo=mercury) by roanoak.netregistry.net with smtp (Exim 3.12 #1 (Debian)) id 15WXFk-0003TA-00 for ; Tue, 14 Aug 2001 16:00:36 +1000 Reply-To: From: "Scott Gilbert" To: Subject: Case sensitivity Date: Tue, 14 Aug 2001 16:09:47 +1000 Message-ID: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_000D_01C124DB.8A0585A0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-MS-TNEF-Correlator: X-Scanner: exiscan *15WXFk-0003TA-00*PdYfOiBNMv2* http://duncanthrax.net/exiscan/ X-Archive-Number: 200108/327 X-Sequence-Number: 13571 This is a multi-part message in MIME format. ------=_NextPart_000_000D_01C124DB.8A0585A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit We intend to move from M$ Access to PostgreSQL, however, much of our legacy code operates under the assumption that string or text comparisons are case insensitive whereas postgres is case sensitive. This issue extends to SQL Select statements as well as straight comparison (i.e. in addition to the <, > and = operators, the WHERE and IN clauses in SQL statements are also issues) so we can't simply modify the function attached to the comparison operators. Is there some means of modifying the behaviour of PostgreSQL so that it is case insensitive? ------=_NextPart_000_000D_01C124DB.8A0585A0 Content-Type: application/ms-tnef; name="winmail.dat" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="winmail.dat" eJ8+Ii8GAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcA GAAAAElQTS5NaWNyb3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEG gAMADgAAANEHCAAOABAACQAAAAIACQEBA5AGAFgGAAAlAAAACwACAAEAAAAL ACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAABAAAAEQAAAENh c2Ugc2Vuc2l0aXZpdHkAAAAAAgFxAAEAAAAWAAAAAcEkh7hCUH0tEpBQEdWF CQAGKRm8SgAAAgEdDAEAAAAmAAAAU01UUDpTQ09UVC5HSUxCRVJUQE5FVFJF R0lTVFJZLkFVLkNPTQAAAAsAAQ4AAAAAQAAGDgBmB5yHJMEBAgEKDgEAAAAY AAAAAAAAALN8AtTBXtURu2cABikZvErCgAAACwAfDgEAAAACAQkQAQAAACoC AAAmAgAAAgMAAExaRnUJVDnuAwAKAHJjcGcxMjUWMgD4C2BuDhAwMzNPAfcC pARkAgBjaArAc/BldDAgCFUHsgKDAFCvA9QQ2QcTAoB9CoF2CJCkd2sLgGQ0 DGBjAFBDCwMLtSBXZSALgHRBCfBkIHRvIARgdpcWIANSBdAkE6BjYweQQwQg FrFQb3N0CcFTAFFMLCBob3dlFRcAchjwbRUAaCBvhmYZ4AhwIGxlZwDQvnkK ogqABaABABngcASQNmEWYAQgdRTAEdF0aKUWIGEEEHVtBTBpAiD7HFEbsCAY cAUQDyAZ4BxB/GV4BUAFoBzgCsAEAAIg1wQgCsAWIGMcoGUaxAuA7xEwAIEd ABcBdxxwCXAcoPwgcBhkBCAEAB+DHZAgZuAuICBUaCIBBAEKUP4gHlEWcRgD GMEaxAZgGmD+Yx2CG7EHgAIwHzEEIBkwnmwDICFBHaELcGdoHnpwIChpLiMB C4AckGSeZCCRHSIWwBxiPCwaxLY+HJAWgT0bZQWwcxjwQRxiV0hFUkUqY0n2 Th6AC2B1ETAh4QOgGME/JZsfYQdAHwAf1SOicynPHZAWwBkwH4FuJx2BB3Bt C1B5FtEo8GYwoBxiZv8cACVwHRIbsAGQEPAJgClW7x6YGsQq1yMRSRgBIQIv gf8HgBbQITAGMRnxMMQd0hxi/GJlEQAUYBoiGfEYWC+B3xrEHVMgkCH3IDk/ GsQ62C8VcRUjOxYUIQA9EAAACwAAgAggBgAAAAAAwAAAAAAAAEYAAAAAA4UA AAAAAAADAAiACCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAMADoAIIAYA AAAAAMAAAAAAAABGAAAAAFKFAAAnagEAHgAPgAggBgAAAAAAwAAAAAAAAEYA AAAAVIUAAAEAAAAEAAAAOS4wAAsAEIAIIAYAAAAAAMAAAAAAAABGAAAAAAaF AAAAAAAAAwARgAggBgAAAAAAwAAAAAAAAEYAAAAAAYUAAAAAAAALABqACCAG AAAAAADAAAAAAAAARgAAAAAOhQAAAAAAAAMAG4AIIAYAAAAAAMAAAAAAAABG AAAAABGFAAAAAAAAAwAdgAggBgAAAAAAwAAAAAAAAEYAAAAAGIUAAAAAAAAe ACyACCAGAAAAAADAAAAAAAAARgAAAAA2hQAAAQAAAAEAAAAAAAAAHgAtgAgg BgAAAAAAwAAAAAAAAEYAAAAAN4UAAAEAAAABAAAAAAAAAB4ALoAIIAYAAAAA AMAAAAAAAABGAAAAADiFAAABAAAAAQAAAAAAAAALADaACCAGAAAAAADAAAAA AAAARgAAAACChQAAAQAAAAIB+A8BAAAAEAAAALN8AtTBXtURu2cABikZvEoC AfoPAQAAABAAAACzfALUwV7VEbtnAAYpGbxKAgH7DwEAAABHAAAAAAAAADih uxAF5RAaobsIACsqVsIAAFBTVFBSWC5ETEwAAAAAAAAAAE5JVEH5v7gBAKoA N9luAAAAQzpcc2NvdHRnLnBzdAAAAwD+DwUAAAADAA00/TcAAAIBfwABAAAA QAAAADxORkJCTExHSExESEtDTE1OSE5CRUlFT0NDRUFBLnNjb3R0LmdpbGJl cnRAbmV0cmVnaXN0cnkuYXUuY29tPgADAAYQe1o9CAMABxDFAQAAAwAQEAAA AAADABEQAAAAAB4ACBABAAAAZQAAAFdFSU5URU5EVE9NT1ZFRlJPTU0kQUND RVNTVE9QT1NUR1JFU1FMLEhPV0VWRVIsTVVDSE9GT1VSTEVHQUNZQ09ERU9Q RVJBVEVTVU5ERVJUSEVBU1NVTVBUSU9OVEhBVFNUUkkAAAAA50o= ------=_NextPart_000_000D_01C124DB.8A0585A0--