Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference?

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