Received: from mail.rdc1.bc.wave.home.com (imail@ha1.rdc1.bc.wave.home.com [24.2.10.66]) by hub.org (8.9.2/8.9.1) with ESMTP id BAA11325 for ; Tue, 2 Mar 1999 01:02:37 -0500 (EST) (envelope-from cjohan@home.com) Received: from home.com ([24.112.123.252]) by mail.rdc1.bc.wave.home.com (InterMail v4.00.03 201-229-104) with ESMTP id <19990302060233.SCIE11952.mail.rdc1.bc.wave.home.com@home.com> for ; Mon, 1 Mar 1999 22:02:33 -0800 Message-ID: <36DB7F03.E3750759@home.com> Date: Mon, 01 Mar 1999 22:02:43 -0800 From: Craig Johannsen X-Mailer: Mozilla 4.05 [en]C-AtHome0404 (Win95; U) MIME-Version: 1.0 To: pgsql-sql@hub.org Subject: Semantics of LIKE References: <199903020400.XAA92240@hub.org> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit How does the LIKE predicate operator treat trailing spaces in a CHAR column. For example, create table test(c1 char(5)); insert into test('abc'); select c1 from test where c1 like 'abc%'; should retrieve one row. select c1 from test where c1 like 'abc'; should retrieve zero rows. select c1 from test where c1 like 'abc '; should retrieve one row. Correct? Does this conform exactly to the SQL 92 spec?