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 f1716Rx66367 for ; Tue, 6 Feb 2001 20:06:27 -0500 (EST) (envelope-from brice@webprojkt.com) Received: (qmail 27394 invoked by uid 604); 7 Feb 2001 01:06:24 -0000 Received: from unknown (HELO webprojkt.com) (24.183.6.53) by morpheus.webprojkt.com with SMTP; 7 Feb 2001 01:06:24 -0000 Message-ID: <3A809F90.9A7C900@webprojkt.com> Date: Tue, 06 Feb 2001 19:06:24 -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/294 X-Sequence-Number: 4166 Ross, Thanx for the heads up on this. The select did indeed return something other than four: 5. I updated as you suggested, but that alone didn't fix the problem. I'm updating tblFDBMono now with the same type of 'fix' to see if this is the root of the problem. Is '=' handled differently between PostgreSQL and MySQL in this case? -Brice "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