Received: from morpheus.webprojkt.com (morpheus.webprojkt.com [209.61.155.148]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f171IMx67796 for ; Tue, 6 Feb 2001 20:18:22 -0500 (EST) (envelope-from brice@webprojkt.com) Received: (qmail 27417 invoked by uid 604); 7 Feb 2001 01:18:18 -0000 Received: from unknown (HELO webprojkt.com) (24.183.6.53) by morpheus.webprojkt.com with SMTP; 7 Feb 2001 01:18:18 -0000 Message-ID: <3A80A25B.B7A669B7@webprojkt.com> Date: Tue, 06 Feb 2001 19:18:19 -0600 From: Brice Ruth X-Mailer: Mozilla 4.75 (Macintosh; U; PPC) X-Accept-Language: en MIME-Version: 1.0 To: "Ross J. Reedstrom" CC: pgsql-general@postgresql.org, pgsql-sql@postgresql.org Subject: Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference? References: <3A79E9E8.238F653B@webprojkt.com> <3A808752.5BF8BB7E@webprojkt.com> <20010206175539.A22236@rice.edu> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200102/296 X-Sequence-Number: 4168 Unfortunately ... that didn't seem to help :( I used btrim on all the fields that were part of an equals (=) statement and reran the select and got the same result (0 rows). After I was in the process of updating the tables, I thought that this may fail ... since again, the 'manual join' of these two tables returns the correct results ... and it uses the same equality tests as the SQL join. I'm more than happy to keep tryin' different things, though ... anything to get to the bottom of this. Regards, Brice Ruth "Ross J. Reedstrom" wrote: > > Brice - > What's the result of > > select monographid,length(monographid) from tblpemdruglink where > monographid ~ '^2008'; > > It occurs to me that your delimited text file may have padded values, > and "=" insists on exact matches for VARCHAR. > > update tblpemdruglink set monographid=btrim(monographid); > > might help, if the first query returns anything but 4. > > Ross > > On Tue, Feb 06, 2001 at 05:22:59PM -0600, Brice Ruth wrote: > > Here's something to chew on ... > > > > The following snippet of SQL produces a result: > > > > > > > Please respond to this newsgroup, the mailing list (which should be > > mirrored on the newsgroup), and/or to me personally. I'm twiddlin' my > > thumbs until I can figure this one out. > > > > Regards, > > Brice Ruth