Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id CF0DB2E01C4 for ; Thu, 13 Dec 2007 07:41:47 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 35423-05 for ; Thu, 13 Dec 2007 07:41:39 -0400 (AST) Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.187]) by postgresql.org (Postfix) with ESMTP id 71C1B2E0258 for ; Thu, 13 Dec 2007 07:41:41 -0400 (AST) Received: by rv-out-0910.google.com with SMTP id l15so570531rvb.43 for ; Thu, 13 Dec 2007 03:41:40 -0800 (PST) Received: by 10.141.20.7 with SMTP id x7mr1007972rvi.255.1197546100682; Thu, 13 Dec 2007 03:41:40 -0800 (PST) Received: by 10.140.164.6 with HTTP; Thu, 13 Dec 2007 03:41:40 -0800 (PST) Message-ID: Date: Thu, 13 Dec 2007 12:41:40 +0100 From: "=?ISO-8859-2?Q?Piotr_Gasid=B3o?=" To: pgsql-performance@postgresql.org Subject: Re: Index on VARCHAR with text_pattern_ops inside PL/PGSQL procedure. In-Reply-To: <475D37D9.3000208@barbara.eu.org> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-2 Content-Transfer-Encoding: base64 Content-Disposition: inline References: <475D37D9.3000208@barbara.eu.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/183 X-Sequence-Number: 27999 MjAwNy8xMi8xMCwgUGlvdHIgR2FzaWSzbyA8cXVha2VyQGJhcmJhcmEuZXUub3JnPjoKPiBXaHkg UEwvUEdTUUwgaXMgdW5hYmxlIHRvIHByb3BlciB1dGlsaXplCj4gdXNlcnNfdXNlcl9uYW1lX3Vu aXF1ZV90ZXh0X3BhdHRlcm5fb3BzPwoKSSBmb3VuZCBzb2x1dGlvbiwgdGhhdCBzYXRpc2ZpZXMg bWUgKEVYRUNVVEUgaXMgYSBiaXQgdWdseSBmb3IgbWUpLgoKSSd2ZSByZXBsYWNlZCBMSUtFIG9w ZXJhdG9yIHdpdGggfj1+IG9wZXJhdG9yLiBOb3cgUEwvUEdTUUwgZnVuY3Rpb24KcHJvcGVybHkg dXNlcyBpbmRleCBvbiBTRUxFQ1QuCg==