| From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | cannot cast bpchar and varchar |
| Date: | 1999-02-10 02:43:39 |
| Message-ID: | 199902100243.LAA24610@srapc451.sra.co.jp |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
It seems that casting varchar and bpchar does not work.
I create two tables.
create table main (id char(4), sub_id char(4), caption char(10));
create table sub (sub_id varchar(10), sub_caption varchar(10));
Then do a select.
select main.id, sub.sub_caption, main.caption from main, sub
where main.sub_id=sub.sub_id;
I get an error(this is normal, I guess).
ERROR: There is more than one possible operator '=' for types 'bpchar' and 'varchar'
You will have to retype this query using an explicit cast
So I try some castings.
test=> select main.id, sub.sub_caption, main.caption from main, sub where main.sub_id::varchar =sub.sub_id;
test=> ERROR: There is more than one possible operator '=' for types 'bpchar' and 'varchar'
You will have to retype this query using an explicit cast
test=> select main.id, sub.sub_caption, main.caption from main, sub where main.sub_id=sub.sub_id::bpchar;
ERROR: There is more than one possible operator '=' for types 'bpchar' and 'varchar'
You will have to retype this query using an explicit cast
test=> select main.id, sub.sub_caption, main.caption from main, sub where cast(main.sub_id as varchar) =sub.sub_id;
ERROR: There is more than one possible operator '=' for types 'bpchar' and 'varchar'
You will have to retype this query using an explicit cast
test=> select main.id, sub.sub_caption, main.caption from main, sub where main.sub_id=cast(sub.sub_id as bpchar);
ERROR: There is more than one possible operator '=' for types 'bpchar' and 'varchar'
You will have to retype this query using an explicit cast
Do we have a problem with casting? BTW, this is 6.4.2. I have not
tried current yet.
--
Tatsuo Ishii
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daryl W. Dunbar | 1999-02-10 03:00:39 | PostgreSQL and Solaris 7? |
| Previous Message | Vadim Mikheev | 1999-02-10 02:28:11 | Re: [HACKERS] TIME QUALIFICATION |