Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 2A8342E002C for ; Fri, 15 Feb 2008 14:23:19 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 20143-01 for ; Fri, 15 Feb 2008 14:23:15 -0400 (AST) Received: from mu-out-0910.google.com (mu-out-0910.google.com [209.85.134.188]) by postgresql.org (Postfix) with ESMTP id 8237E2E002E for ; Fri, 15 Feb 2008 14:23:15 -0400 (AST) Received: by mu-out-0910.google.com with SMTP id i10so783243mue.5 for ; Fri, 15 Feb 2008 10:23:14 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=g2SA6kv7vCVsNchziCaM2G9E8poIn6DdCEtN56NToEA=; b=OcoVZmzxbb0aJolCjoprNbczYfc+RJRLnHynQGaAIMjfz5WUQcV97j6NvTilcnMZGtLNBkPNyo12VJuuPdmC4VVKqW3Yt7HREQVjYKd+D42MpvO6ucLwQZYkRHr2r9pSlahnmywKKj+6KDmHtxwzgkJmkB9IZn2/gKufc61aSn0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=j1fSqq+8vsILOLFLa6WinmmiQY2DuuPi2UuSQiCGrCUSXzh5XPR8E/uVV24437tD/BzqHW/aAmOUAs7CQlJNslIZUReZC8Php35xJ0CKbxpvm8tyIXGmfTAcQR+1YEErl8wu7SweRYjQl2qzhLPl62Ew5IXvIc7hB5H/jIG64Kw= Received: by 10.78.18.12 with SMTP id 12mr3944297hur.5.1203099792858; Fri, 15 Feb 2008 10:23:12 -0800 (PST) Received: by 10.78.41.7 with HTTP; Fri, 15 Feb 2008 10:23:12 -0800 (PST) Message-ID: <162867790802151023i5a2276bj17f3f666aa4e6827@mail.gmail.com> Date: Fri, 15 Feb 2008 19:23:12 +0100 From: "Pavel Stehule" To: "=?UTF-8?Q?Rodrigo_E._De_Le=C3=B3n_Plicet?=" Subject: Re: String function to Find how many times str2 is in str1? Cc: emilu@encs.concordia.ca, "PostgreSQL SQL List" In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 Content-Disposition: inline References: <47B5B944.4010203@encs.concordia.ca> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/132 X-Sequence-Number: 30223 SGVsbG8KCndoYXQgYWJvdXQKCkNSRUFURSBPUiBSRVBMQUNFIEZVTkNUSU9OIEZvb2Jhcih0ZXh0 LCB0ZXh0KQpSRVRVUk5TIGludGVnZXIgQVMgJCQKU0VMRUNUIGFycmF5X3VwcGVyKHN0cmluZ190 b19hcnJheSgkMSwkMiksMSkgLSAxOwokJCBMQU5HVUFHRSBTUUwgSU1NVVRBQkxFOwoKT24gMTUv MDIvMjAwOCwgUm9kcmlnbyBFLiBEZSBMZcOzbiBQbGljZXQgPHJkZWxlb25wQGdtYWlsLmNvbT4g d3JvdGU6Cj4gT24gRnJpLCBGZWIgMTUsIDIwMDggYXQgMTE6MDkgQU0sIEVtaSBMdSA8ZW1pbHVA ZW5jcy5jb25jb3JkaWEuY2E+IHdyb3RlOgo+ICA+ICBTdHIxID0gInRlc3QgICB0ZXN0ICAgY2Fh ICAgZHRlc3QgICB0ZXN0aW5nICAgRW5kb2ZTdHJpbmciOwo+ICA+ICBTdHIyID0gIiAgICI7Cj4g ID4KPiAgPiAgc2VsZWN0IGZ1bmNOYW1lKFN0cjEsIFN0cjIpOwo+ICA+Cj4gID4gIHJldHVybiA1 Cj4KPgo+IENSRUFURSBPUiBSRVBMQUNFIEZVTkNUSU9OCj4gICBGT09CQVIoVEVYVCxURVhUKQo+ ICBSRVRVUk5TIElOVCBBUyAkJAo+ICAgU0VMRUNUKExFTkdUSCgkMSkgLSBMRU5HVEgoUkVQTEFD RSgkMSwgJDIsICcnKSkpIC8gTEVOR1RIKCQyKSA7Cj4gICQkIExBTkdVQUdFIFNRTCBJTU1VVEFC TEU7Cj4KPiAgU0VMRUNUIEZPT0JBUigndGVzdCAgIHRlc3QgICBjYWEgICBkdGVzdCAgIHRlc3Rp bmcgICBFbmRvZlN0cmluZycsICcgICAnKTsKPgo+ICAgZm9vYmFyCj4gIC0tLS0tLS0tCj4gICAg ICAgNQo+ICAoMSByb3cpCj4KPiAgR29vZCBsdWNrLgo+Cj4gIC0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLShlbmQgb2YgYnJvYWRjYXN0KS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQo+ICBU SVAgMjogRG9uJ3QgJ2tpbGwgLTknIHRoZSBwb3N0bWFzdGVyCj4K