Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [206.210.65.6]) by hub.org (8.9.3/8.9.3) with ESMTP id TAA31259 for ; Tue, 15 Jun 1999 19:16:12 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id TAA23969; Tue, 15 Jun 1999 19:14:45 -0400 (EDT) To: Charles cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Maybe a bug with SQL processor In-reply-to: Your message of Tue, 15 Jun 1999 15:01:50 -0300 <3.0.6.32.19990615150150.00797960@10.0.0.67> Date: Tue, 15 Jun 1999 19:14:44 -0400 Message-ID: <23967.929488484@sss.pgh.pa.us> From: Tom Lane Hint: this'd work a lot better if levelstr were declared varchar() or text. The padding spaces for char() are messing up your match pattern. regards, tom lane