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 по дате отправления: