From: | "Nikolay Mijaylov" <nmmm(at)webfactory(dot)bg> |
---|---|
To: | "pgsql-general" <pgsql-general(at)postgreSQL(dot)org>, <pgsql-sql(at)postgreSQL(dot)org>, <pgsql-error(at)postgreSQL(dot)org> |
Subject: | Whats happen here? |
Date: | 1999-12-06 15:13:00 |
Message-ID: | 000501bf3ffc$638f2fe0$ce2a18c3@skillbrokers.bg |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
Whats happen here?
-------------------------
root=> \dt
Database = root
+------------------+----------------------------------+----------+
| Owner | Relation | Type |
+------------------+----------------------------------+----------+
| root | x | table |
| root | y | table |
+------------------+----------------------------------+----------+
root=> \d x
Table = x
+----------------------------------+----------------------------------+-----
--+
| Field | Type |
Length|
+----------------------------------+----------------------------------+-----
--+
| a | char() |
20 |
+----------------------------------+----------------------------------+-----
--+
root=> \d y
Table = y
+----------------------------------+----------------------------------+-----
--+
| Field | Type |
Length|
+----------------------------------+----------------------------------+-----
--+
| a | varchar() |
5 |
+----------------------------------+----------------------------------+-----
--+
root=>select * from x a, y b where a.a = b.a;
ERROR: There is more than one possible operator '=' for types 'bpchar' and
'varchar'
You will have to retype this query using an explicit cast
--------------------------------------------------------------
The reboots are for hardware upgrades!
"http://www.nmmm.nu; <nmmm(at)nmmm(dot)nu>
From | Date | Subject | |
---|---|---|---|
Next Message | Nikolay Mijaylov | 1999-12-06 15:17:59 | Fw: Whats happen here? |
Previous Message | vincent leycuras | 1999-12-06 13:44:37 | java and postgres |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 1999-12-06 15:14:02 | Re: [SQL] Wierd stuff |
Previous Message | Assaf Gottlieb | 1999-12-06 13:55:41 | OLE-DB vs. ODBC performance on SQL Server 7.0: |