Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f17FmZx67259; Wed, 7 Feb 2001 10:48:35 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f17FmL928369; Wed, 7 Feb 2001 10:48:21 -0500 (EST) To: Brice Ruth cc: Michael Fork , Ian Harding , pgsql-general@postgresql.org, pgsql-sql@postgresql.org Subject: Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference? In-reply-to: <3A816921.FEB47B80@webprojkt.com> References: <3A816921.FEB47B80@webprojkt.com> Comments: In-reply-to Brice Ruth message dated "Wed, 07 Feb 2001 09:26:23 -0600" Date: Wed, 07 Feb 2001 10:48:21 -0500 Message-ID: <28366.981560901@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200102/333 X-Sequence-Number: 4206 Brice Ruth writes: > SELECT length(monographid) FROM tblpemdruglink WHERE drugid='DG-5039'; > I get 5 returned to me, even though the string is only 4 ('2008'). Okay, so you've got some invisible character in there, but not a space (else the trim() woulda got rid of it). Tab maybe? Might want to go back and examine your original data file more carefully, with an editor that will show you control characters and such. regards, tom lane