| From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
|---|---|
| To: | "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
| Cc: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>, pgsql-hackers(at)postgreSQL(dot)org |
| Subject: | Re: [HACKERS] cannot cast bpchar and varchar |
| Date: | 1999-02-10 08:59:01 |
| Message-ID: | 199902100859.RAA28146@srapc451.sra.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
>Hmmm. It seems to be a combination of two problems:
>
>1) not knowing which type should be preferred (or how to compare varchar
>and bpchar; should I strip the blank padding from a bpchar? Probably
>so...).
>
>2) swallowing the type coersions since bpchar, varchar, and text are
>considered to be binary compatible. I may have seen another instance of
>this being a problem, and perhaps should figure out how to propagate the
>new coerced type into the query rather than dropping it.
>
>Will look at this. Question: how *should* we compare bpchar and varchar?
>It may be that we should have some explicit comparison or coersion
>routines to make things work smoothly.
Not sure. I will check some SQL books at home.
--
Tatsuo Ishii
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 1999-02-10 09:26:34 | Re: [HACKERS] TIME QUALIFICATION |
| Previous Message | Tatsuo Ishii | 1999-02-10 08:56:50 | Re: [HACKERS] PostgreSQL and Solaris 7? |