Whats happen here?
| От | Nikolay Mijaylov |
|---|---|
| Тема | Whats happen here? |
| Дата | |
| Msg-id | 000501bf3ffc$638f2fe0$ce2a18c3@skillbrokers.bg обсуждение |
| Список | pgsql-general |
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@nmmm.nu>
В списке pgsql-general по дате отправления: