From: Brice Ruth <brice@webprojkt.com>
To: Ross J. Reedstrom <reedstrm@rice.edu>
Cc: pgsql-general@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference?
Date: Tue, 06 Feb 2001 19:06:24 -0600
Message-ID: <3A809F90.9A7C900@webprojkt.com> (raw)
References: <3A79E9E8.238F653B@webprojkt.com>
<3A808752.5BF8BB7E@webprojkt.com>
<20010206175539.A22236@rice.edu>
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:
> >
>
> <SNIP>
>
> > 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: brice@webprojkt.com, reedstrm@rice.edu, pgsql-general@postgresql.org
Subject: Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference?
In-Reply-To: <3A809F90.9A7C900@webprojkt.com>
References: <3A79E9E8.238F653B@webprojkt.com> <3A808752.5BF8BB7E@webprojkt.com> <20010206175539.A22236@rice.edu> <3A809F90.9A7C900@webprojkt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox