| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Brice Ruth <brice(at)webprojkt(dot)com> |
| Cc: | Michael Fork <mfork(at)toledolink(dot)com>, Ian Harding <iharding(at)pakrat(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference? |
| Date: | 2001-02-07 15:48:21 |
| Message-ID: | 28366.981560901@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
Brice Ruth <brice(at)webprojkt(dot)com> writes:
> SELECT length(monographid) FROM tblpemdruglink WHERE drugid='DG-5039';
> I get 5 returned to me, even though the string is only 4 ('2008').
Okay, so you've got some invisible character in there, but not a space
(else the trim() woulda got rid of it). Tab maybe? Might want to go
back and examine your original data file more carefully, with an editor
that will show you control characters and such.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fork | 2001-02-07 15:48:23 | Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference? |
| Previous Message | Richard Huxton | 2001-02-07 15:47:08 | Re: numeric type and odbc from access 2000 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fork | 2001-02-07 15:48:23 | Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference? |
| Previous Message | Tom Lane | 2001-02-07 15:43:25 | Re: Load or Copy ?? |