X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id BA37B53671 for ; Wed, 4 May 2005 17:43:44 -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 11582-08 for ; Wed, 4 May 2005 20:43:40 +0000 (GMT) Received: from mail.astudios.com (ns1.astudios.com [66.49.77.3]) by svr1.postgresql.org (Postfix) with ESMTP id 8574D535F9 for ; Wed, 4 May 2005 17:43:39 -0300 (ADT) thread-index: AcVQ6fy/+tnnk6xRS4+ZN3hQ6rXcMg== Received: from [10.4.13.50] ([66.194.26.150]) by mail.astudios.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 4 May 2005 16:43:54 -0400 Content-Class: urn:content-classes:message Importance: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830 Message-ID: <4279345D.9030603@sermonaudio.com> Date: Wed, 04 May 2005 16:45:17 -0400 From: "Chris Hoover" User-Agent: Mozilla Thunderbird 0.8 (X11/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "PostgreSQL Admin" Subject: Anything like varchar_pattern_ops in 7.3.x? Content-Type: text/plain; format=flowed; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 04 May 2005 20:43:54.0750 (UTC) FILETIME=[FCB8D1E0:01C550E9] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200505/44 X-Sequence-Number: 17473 I have been looking into the Postgresql 8 docs and noticed that they have a varchar_pattern_ops operator class to help get around the problem with like and non-C locales. I am trying to find out if there is any thing like this in the 7.3 server since we are still a good 6+ months from being able to roll out Postgresql 8.x. Thanks, Chris