X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8510852AA3 for ; Mon, 25 Jul 2005 14:31:35 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 34146-10 for ; Mon, 25 Jul 2005 17:31:26 +0000 (GMT) Received: from mail.rusa.at (mail.rusa.at [194.152.181.37]) by svr1.postgresql.org (Postfix) with ESMTP id B95BF52ABC for ; Mon, 25 Jul 2005 14:31:24 -0300 (ADT) Received: (qmail 7514 invoked by uid 210); 25 Jul 2005 19:11:30 +0200 Received: from 85.124.3.117 by norb (envelope-from , uid 201) with qmail-scanner-1.24st (clamdscan: 0.75.1. bitdefender: v7.0/2490/91218. spamassassin: 2.64. perlscan: 1.23st. Clear:RC:0(85.124.3.117):SA:0(-2.2/5.0):. Processed in 5.3814 secs); 25 Jul 2005 17:11:30 -0000 Received: from 85-124-3-117.dynamic.xdsl-line.inode.at (HELO ?192.168.100.192?) (chris@rusa.at@85.124.3.117) by 10.50.30.3 with AES256-SHA encrypted SMTP; 25 Jul 2005 19:11:24 +0200 Message-ID: <42E521DF.4000804@rusa.at> Date: Mon, 25 Jul 2005 19:31:11 +0200 From: Christian Rusa User-Agent: Mozilla Thunderbird 1.0 (Macintosh/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Closes Match Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=sha1; boundary="------------ms040903010602020106060605" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 tagged_above=0 required=5 tests=RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200507/223 X-Sequence-Number: 22201 This is a cryptographically signed message in MIME format. --------------ms040903010602020106060605 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Hi there, I want to match a string against the database and get the closest (shorter) match. I was asking myself if its possible to realise this in SQL. So if the string is: abcdefg And in the database are entries like: a ab abc I just want to get back 'abc'. I looked around in the internet and the documentation but found no solution. Cheers Christian --------------ms040903010602020106060605 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIII6TCC As8wggI4oAMCAQICAw8xPjANBgkqhkiG9w0BAQQFADBiMQswCQYDVQQGEwJaQTElMCMGA1UE ChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNv bmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EwHhcNMDUwNzI1MDkwNTA0WhcNMDYwNzI1MDkwNTA0 WjBDMR8wHQYDVQQDExZUaGF3dGUgRnJlZW1haWwgTWVtYmVyMSAwHgYJKoZIhvcNAQkBFhFj aHJpc3RpYW5AcnVzYS5hdDCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAPTIQLlp 7AoljveWA2T6Ma2ExL5/MjKpH3ed+iyqci9AsMvjpoMCWg0KRfJ+QX+EU8uHAyDTsjVKEfGh SNbXVvfsktfKGkZyhvqmbOQvdUM+3AvIni13zIADiNg9WHR94Jg2rCbl70vBaZYbOl8RCWyi sfub6zXttG7zCsg74bNyhg6A6HR2BO5hFjnSG1uuW92wh/s0ekGIabwXOje7RAUrOU35LZVw 5aqJIULOHdWwvHXZ3A+NkDwPHzyNKdFQAwr30hauJCG6WyGkYTzbaOdkATmTcXtXAoOrrNkr d8GJCkCRJFxrsB4alofTHH9Hp6Tn6qyfkjwO1UCHLbEuIG8CAwEAAaMuMCwwHAYDVR0RBBUw E4ERY2hyaXN0aWFuQHJ1c2EuYXQwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQQFAAOBgQCL I84aLmONQ2hBzQ1B5qXqVTyEp/M4wINlj/ggP7IX9UNLi7qnegHPU7XWmh63ri0gXbHKuwHE 9h+iznb15kxJPjMo1d8ZbkX+XtXqt14j9LFR9Y9BryAmsbhT5lA5+KBKIBZhsKuRBHm6/1oI CpqGz0L3Inlru3/yV4FLvceP5jCCAs8wggI4oAMCAQICAw8xPjANBgkqhkiG9w0BAQQFADBi MQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEs MCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EwHhcNMDUwNzI1 MDkwNTA0WhcNMDYwNzI1MDkwNTA0WjBDMR8wHQYDVQQDExZUaGF3dGUgRnJlZW1haWwgTWVt YmVyMSAwHgYJKoZIhvcNAQkBFhFjaHJpc3RpYW5AcnVzYS5hdDCCASIwDQYJKoZIhvcNAQEB BQADggEPADCCAQoCggEBAPTIQLlp7AoljveWA2T6Ma2ExL5/MjKpH3ed+iyqci9AsMvjpoMC Wg0KRfJ+QX+EU8uHAyDTsjVKEfGhSNbXVvfsktfKGkZyhvqmbOQvdUM+3AvIni13zIADiNg9 WHR94Jg2rCbl70vBaZYbOl8RCWyisfub6zXttG7zCsg74bNyhg6A6HR2BO5hFjnSG1uuW92w h/s0ekGIabwXOje7RAUrOU35LZVw5aqJIULOHdWwvHXZ3A+NkDwPHzyNKdFQAwr30hauJCG6 WyGkYTzbaOdkATmTcXtXAoOrrNkrd8GJCkCRJFxrsB4alofTHH9Hp6Tn6qyfkjwO1UCHLbEu IG8CAwEAAaMuMCwwHAYDVR0RBBUwE4ERY2hyaXN0aWFuQHJ1c2EuYXQwDAYDVR0TAQH/BAIw ADANBgkqhkiG9w0BAQQFAAOBgQCLI84aLmONQ2hBzQ1B5qXqVTyEp/M4wINlj/ggP7IX9UNL i7qnegHPU7XWmh63ri0gXbHKuwHE9h+iznb15kxJPjMo1d8ZbkX+XtXqt14j9LFR9Y9BryAm sbhT5lA5+KBKIBZhsKuRBHm6/1oICpqGz0L3Inlru3/yV4FLvceP5jCCAz8wggKooAMCAQIC AQ0wDQYJKoZIhvcNAQEFBQAwgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENh cGUxEjAQBgNVBAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRpbmcxKDAm BgNVBAsTH0NlcnRpZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0 ZSBQZXJzb25hbCBGcmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1h aWxAdGhhd3RlLmNvbTAeFw0wMzA3MTcwMDAwMDBaFw0xMzA3MTYyMzU5NTlaMGIxCzAJBgNV BAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQD EyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQTCBnzANBgkqhkiG9w0BAQEF AAOBjQAwgYkCgYEAxKY8VXNV+065yplaHmjAdQRwnd/p/6Me7L3N9VvyGna9fww6YfK/Uc4B 1OVQCjDXAmNaLIkVcI7dyfArhVqqP3FWy688Cwfn8R+RNiQqE88r1fOCdz0Dviv+uxg+B79A gAJk16emu59l0cUqVIUPSAR/p7bRPGEEQB5kGXJgt/sCAwEAAaOBlDCBkTASBgNVHRMBAf8E CDAGAQH/AgEAMEMGA1UdHwQ8MDowOKA2oDSGMmh0dHA6Ly9jcmwudGhhd3RlLmNvbS9UaGF3 dGVQZXJzb25hbEZyZWVtYWlsQ0EuY3JsMAsGA1UdDwQEAwIBBjApBgNVHREEIjAgpB4wHDEa MBgGA1UEAxMRUHJpdmF0ZUxhYmVsMi0xMzgwDQYJKoZIhvcNAQEFBQADgYEASIzRUIPqCy7M DaNmrGcPf6+svsIXoUOWlJ1/TCG4+DYfqi2fNi/A9BxQIJNwPP2t4WFiw9k6GX6EsZkbAMUa C4J0niVQlGLH2ydxVyWN3amcOY6MIE9lX5Xa9/eH1sYITq726jTlEBpbNU1341YheILcIRk1 3iSx0x1G/11fZU8xggM7MIIDNwIBATBpMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3 dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJl ZW1haWwgSXNzdWluZyBDQQIDDzE+MAkGBSsOAwIaBQCgggGnMBgGCSqGSIb3DQEJAzELBgkq hkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTA1MDcyNTE3MzExMVowIwYJKoZIhvcNAQkEMRYE FIjhH/Gc1cYG6aUeWA6P+IUdSut+MFIGCSqGSIb3DQEJDzFFMEMwCgYIKoZIhvcNAwcwDgYI KoZIhvcNAwICAgCAMA0GCCqGSIb3DQMCAgFAMAcGBSsOAwIHMA0GCCqGSIb3DQMCAgEoMHgG CSsGAQQBgjcQBDFrMGkwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0 aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1 aW5nIENBAgMPMT4wegYLKoZIhvcNAQkQAgsxa6BpMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQK ExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29u YWwgRnJlZW1haWwgSXNzdWluZyBDQQIDDzE+MA0GCSqGSIb3DQEBAQUABIIBADpY2lv08IXB jJ4DN3KsbuDlL4Njx7fm/S0MFmCDEK+Zm8X4xjpEE8NfWNIT3dSMmZIP4hY/H/bx24YX9a6o nyIR0bpIRiBn6KvRuvVsrSbYekX129bbe+eQBfJTeMzxBj6s/9zhCUiC6CVsjkcV25zDL7Ez jEymdXO8ZmMjF/7tdnCTUWczKxiN3zgWHCTeYR7aDTIeE2R5ede+rZMMnf1vZ/ZmKrBi4Eq+ 3mppDox1Lx0cA4t78p5w1qgbqLSDSbAi/1FaEnb7+89uWNIgeypBIfaH6mnPaZCdbqtK29uV MH2giNzO4YwCFjhQ7XdaI6qXQi8bxDfubpnivesiqHAAAAAAAAA= --------------ms040903010602020106060605--