Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f17DfMx51049 for ; Wed, 7 Feb 2001 08:41:22 -0500 (EST) (envelope-from pgsql-general-owner@postgresql.org) Received: from wallace.ece.rice.edu (wallace.ece.rice.edu [128.42.12.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f16Ntnx56545; Tue, 6 Feb 2001 18:55:50 -0500 (EST) (envelope-from reedstrm@rice.edu) Received: by rice.edu via sendmail from stdin id (Debian Smail3.2.0.102) for pgsql-general@postgresql.org; Tue, 6 Feb 2001 17:55:39 -0600 (CST) Date: Tue, 6 Feb 2001 17:55:39 -0600 From: "Ross J. Reedstrom" To: Brice Ruth Cc: pgsql-general@postgresql.org, pgsql-sql@postgresql.org Subject: Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference? Message-ID: <20010206175539.A22236@rice.edu> Mail-Followup-To: Brice Ruth , pgsql-general@postgresql.org, pgsql-sql@postgresql.org References: <3A79E9E8.238F653B@webprojkt.com> <3A808752.5BF8BB7E@webprojkt.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.0i In-Reply-To: <3A808752.5BF8BB7E@webprojkt.com>; from brice@webprojkt.com on Tue, Feb 06, 2001 at 05:22:59PM -0600 X-Archive-Number: 200102/320 X-Sequence-Number: 4192 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